Say you have a SQL Server Integration Services (SSIS) package with a Foreach Loop container. Inside that container you have a task that sometimes can fail. Koen Verbeeck provides a tip on how to implement SSIS so that, if it fails, the loop will just continue, skip the current step and go to the next iteration.
2015-04-23
7,361 reads
An SSIS ETL package created with the Import/Export Wizard uses a Data Flow Task to process one data file at a time. If the need arises, however, the Data Flow Task generated by the wizard can be embedded inside a Foreach Loop Container to batch-process a continuous stream of data files.
2013-06-13
7,434 reads
Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools
2013-03-11
8,355 reads
They are the same stored procedure that runs in QA and via jobs. I have added 'with recompile' to the stored procedures but that has made no difference to the speed. There are scheduled jobs that overlap but only due to the time they take to run via jobs. They are scheduled two hours apart and when […]
2004-07-06
I have applied a trigger on inserts of a table. The triger might execute for 10 or even more seconds depending upon the data in the table. The trigger also affect other tables as well. When a record is inserted into the table, the triger fires and starts executing. Now suppose that as soon as […]
2004-02-09
5 reads
Hi All, Might someone be able to point me in the direction of a scriptthat I can build to be executed to pull all the data or "some" (where =)data from a SQL Serv. DB into a .CSV? Thnx
2004-02-06
Check the actual values in sysusers for your uid and sysobjects for the object id, then check syspermissions. See if you already ahve permissionsIt could be because you are dbo.
2004-02-06
2 reads
2004-01-22
1 reads
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
By Rob Sewell
A website can change the world. If you're a student, we'd like to help...
By Rob Sewell
The partner directory connects your agency with new customers.
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers