I have some SSIS packages deployed on server with windows authentication (my user account) using protection level as ServerStorage. Also SQL admin has created jobs to run these packages, admin account is the owner of all the jobs. The jobs are running fine till date but now since my work is over my account will be deleted from AD and I a...
Hi All, I am using the flat file source for a large data migration and the source data in the text stream form unlike UI, datetime or sting. The component is not supporting for fast parsing for text stream. Could I get any ideas to improve fast performance in this scenario. thanks prav ...
Hi All, We have an environment where we develop within T-SQL, SSIS and SSRS. We have core databases for our own systems, but we have dependencies to another SQL system that we directly extract data from by calling tables, views and stored procs (not ideal, but that is for another day). As a developer I want to make sure that at any po...
Am attempting to use SSIS flat file source to read a log file being actively written to. Looping and waiting for the file to be released is not practical as this is an active log file held by a service. Ideally, I'm looking for a setting upon the flat file source, similar to the C# code below. If not that, what route can I take to rea...
Hi I need to use SSIS to cycle through a bunch of .gif images in a folder and import each one into a single row in a table, which contains fields such as filename and size, but more crucially, the binary from the file. I will use a foreach loop to cycle through the files, and probably a script transformation to assign variables to cert...
Hi, i am having a problem in executing the SSIS package through an asp.net application. i'm using c#. every time i run the package through web, i think the package is not disposed properly so until and unless i stop the application the package won't execute...i am not able to dispose or unload the package... i'm geeting errors like 'W...
Hi, i am having a problem in executing the SSIS package through an asp.net application. i'm using c#. every time i run the package through web, i think the package is not disposed properly so until and unless i stop the application the package won't execute...i am not able to dispose or unload the package... i'm geeting errors like 'We...
I'm trying, unsuccessfully, to remotely execute an SSIS package. The package resides on a SQL Server 2008 instance and I'd like to call it from a Job on a 2005 server. The error I'm getting is: The package could not be loaded. The step failed. If I go from 2008 to 2008, there is no error. Any ideas? ...
I am getting an error randomly for a scheduled SSIS package which runs hourly. The funniest thing is that if I delete the checkpoint file and run the package again it works fine but the error may show up at a future run. I have no clue why this is happening. Here is the full error message. Executed as user: UserNameChanged. Microsoft...
I am using SSIS to do data transformation from excel to OLEDB SQL. I have a set of sheets in a folder that i ll have to loop thru and insert the data in each of these sheets to a table. I have a scenario where i have to loop thru a set of Excel sheets that has different column structures. I can loop thru each sheet thru foreach loop enum...
Hi I have this requirement: Pipe delimited text file to a table (TEST) in the SQL db - yes this is fine Now i need to group the results based on the primary key and return the result set as a delimited (pipe deliited string) to a variable. This variable is then used as an input parameter to a stored proc which later processes stuff. ...
I have an SSIS package on Sql server 2008 which inserts data into a table in a transaction. There is a trigger on the table. That is causing the following exception while inserting - Bulk Insert with another outstanding result set should be run with XACT_ABORT on I am using OLEDB. How can I fix the error. ...
I'm currently working on a project where we have a large data warehouse which imports several GB of data on a daily basis from a number of different sources. We have a lot of files with different formats and structures all being imported into a couple of base tables which we then transpose/pivot through stored procs. This part works fi...
We have an SSIS package that is launched from a web service. In the Dev environment, everything works fine, but in the QA environment I get the following error when trying to run the package: "Failed to acquire connection [ConnectionName]. Connection may not be configured correctly or you may not have the right permissions on this conne...
The company I work for has a lot of systems where the source data originates as a flat file or Excel workbook. These files are then imported using DTS into a SQL Server database. Quite often these files contain various control characters (for instance I've just spent an hour finding that some records have a \0 in them which apparently S...
I have the following scenario which runs every night using SSIS in SQL Server 2008: create a few temp. tables, and import data from an ODBC data source when the imports are complete, drop existing tables, and rename the temp. tables to the same name as the dropped tables What do I need to do in either my SSIS job or SQL Server settin...
My current workflow to address data quality issues is Open SSIS Project in Visual Studio Start SSIS Debugger Wait for Errors to Halt Processing Stop Debugger Address Errors (Update Derived Column Transformation) Start SSIS Debugger Hang after "Execute phase is beginning." - with some or no rows extracted Reboot I'd like to avoid ste...
I want to take a series of xml files and pull the xml of the file into a table in the database. I have a for each file enumerator, then an xml task to pull out the dtd and put the contents in a variable. Now that I have the file name and the contents in a variable, I need to insert both pieces of data into the database. My table to st...
I have an Oracle source, and I'm getting the entire table, and it is being copied to a SQL Server 2008 table that looks the same. Just for testing, I would like to only get a subset of the table. In the old DTS packages, under Options on the data transform, I could set a first and last record number, and it would only get that many r...
We are doing a feasibility on what we're going to propose as a solution to a client who wants to migrate to a .NET based solution. Part of the data resides in UniData. What is required can be achieve using the following tool: http://www.welland.com/export.html The above product ETLs data from UniData to SQL Server. As a first step, we...