You may see the above error if you are using the SQL server Destination in your SSIS package. Sql server Destination cannot be used in packages that access a SQL Server database on a remote server. Instead use the OLEDB destination. Things to note for SQL Server Destination a. It offers the same speed as [...]
Jan
17
2010
17
2010
Nov
7
2009
7
2009
Encryption in SQL SERVER using SSIS
I have been recently working on an Sql Server Encryption Project. It includes getting the data from a source and importing them into the Datawarehouse via the ETL(SSIS in this case) and then Encrypting it. I decided to blog on Encryption to share my experience. a. When you Encrypt the Data in SSIS make sure [...]
Jun
20
2009
20
2009
Adding Expressions in SSIS – Connection Strings
Expressions are powerful in Integration Services. With Expressions you can dynamically set the servername (based on the environment) or the name of the excel file(if it is a fixed format). Let me give you an example. I have a simple Dataflow task(as shown below) that gets the data from a table and exports it in [...]
