Whenever you create a new Subscription in Sql server reporting services, a new job is created under the Sql agent as shown in the figure below.
You can use the msdb.dbo.sp_start_job procedure to start the job. In SSIS create a new SQL task and run the job wherever required
exec msdb.dbo.sp_start_job @job_name = ‘JobName’
For more [...]
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 [...]
The Problem occurs when an aggregate function(max,sum,avg..) exists on null values. Trying to get rid of the null values may be the solution but in certain cases..you may need the extra data relying on the null values.
So whats the solution?
Append set ANSI_WARNINGS OFF on the beginning of the sql statement.
When using the same in SSIS [...]
My Twitter Feed
