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 the Bulk [...]
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 you [...]
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 a [...]
My Twitter Feed
