I have data in sharepoint which has 104 columns and 708 rows. This data is basically contains information about enterprise. The senior management wants to view different charts by using these data suc
The users from other departments ask me to grant them to execute Schedule Jobs / SSIS in SQL Server Agent.At present, they cannot see SQL Server Agent tree in their ManagmentStudio.I think, it\'s beca
Our team manages multiple versions of dtsconfig files, one for each release environment, and I am trying to see if there is a way to avoid this and see if there is a simpler way.
When I run it I get the following error: Error at Data Flow Task [SQL Server Destination [164]]: The column
I am invoking a Storedprocedure from SSIS Package. This storedprocedure has three input parameters like Start Date, End Date and a String Variable.
Is it possible to insert a data flow task between two existing tasks in an SSIS package? I have a data flow that is in pretty good shape. During testing the data flow logic, I found that I need an ad
In SSIS, I want to send a 开发者_如何学运维mail stating the number of rows imported by a \"Data Flow Task\".
I am maintaining an SSIS package which extracts data from an Oracle 10g database. When the connection timed out with the error code:
I have created a package which takes a variable from batch file and uses it for execution. I am sending it from batch file as:
I have an SSIS package which imports the data into the SQL Server 2008 database. I have set up the schedule job in the SQL Server Agent to run that package.When I check the history, I could only see w