I have a dtsx package running in SSIS on our SQL server (2016 SP2 CU6), its a lightweight task of importing an Excel (xlsx) worksheet into a table in SQL as-is, no transformations needed at this stage, there is an agent job that does a lot more around it but I can see the fault is occurring in just this
Tag: ssis
How to fix slow running SSIS package
I am trying to insert large amount of data from one table from PROD DB to table in Archive DB. Tables are with the identical schema and archive table is with drooped indexes and “Identity insert on”. …
Is there any way to insert below nested json data into sql server
I am working on a nested JSON data which I need to load into SQL SERVER 2012. The nested JSON contains two roots i.e. one column and another rows. I need to put value from row into the column. Please …
SSIS Looping with Return Value from Stored Procedure
I am trying to create a SSIS Package that loops based on the return value of a stored procedure run in the loop. I keep getting a super NOT helpful error of: “Error: 0xC002F210 at Load Order, …
Can you perform more than operation in a T-SQL MERGE section?
I’ve been fairly successful with my attempts I need to identify and solidify the OUTPUT columns ( # thereof) and what part of the MERGE statement that #of columns truly correlates to. I am simply …
Best way to start SSIS catalog or SSIS package remotely
I need to execute an SSIS package or an SSIS catalog remotely. What is the best way to acomplish this? I’m using: Visual Studio 2012 SQL Server 2012 Answer I am almost positive you need an integration server to accomplish this. The package is stored in the MSBD of the integration server and called by job or execution statement from
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
I’m trying to import a flat file into an oledb target sql server database. here’s the field that’s giving me trouble: here are the properties of that flat file connection, specifically the field: here’s the error message: [Source – 18942979103_txt [424]] Error: Data conversion failed. The data conversion for column “recipient-name” returned status value 4 and status text “Text was
The job failed. The job was invoked by user. The last step to run was step1
I have created SSIS package which is running successfully and dumping the data to the required place. But the same package results in the error when i run it through job. I googled n got these links but failed to get the way out- http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/9034bdc4-24fd-4d80-ad8d-cc780943397a/ http://www.progtown.com/topic390755-error-at-start-job-the-job-was-invoked-by-user-sa.html Please suggest . Answer The screen captures are great but the detail is going
Data flow task executing successfully but not writing any rows to Excel file
I am working on SSIS package that is fetching data from SQL server and inserting into Excel file… in Data Flow Task i’ve used OLE Db source and Excel destination. After configuring OLE Db source i can preview the resulting row and even data flow task executing successfully without giving any error.. but not inserting any row.. Answer Well fortunately
how to cast datetime2 as datetime
I’m trying to convert datetime2 to datetime in order to create a standard between different sources using only SQL or SSIS Take the following SQL query as example: SELECT CAST(offer_start_date AS …