Viewing 15 posts - 121 through 135 (of 669 total)
andrew.diniz (3/8/2012)
March 8, 2012 at 10:26 am
CGSJohnson (2/23/2012)
For each iteration of the FEL? Or does it open one connection? Thanks.
It is one open connection for all data exhange(s).
February 23, 2012 at 9:44 am
pmcdonald (2/23/2012)
Is this only available for SQL Server 2012?
No, it is available in earlier versions also.
February 23, 2012 at 9:08 am
The looping construct will take care of the "Send Multiple" File, as it loops over the source folder structure to get file(s).
February 23, 2012 at 5:32 am
The IS Engine would open connection fetch/send all data and close connection.
February 23, 2012 at 5:29 am
No, the FTP task cannot be used to establish a secure FTP connection.
Nevertheless, you can follow my blog on SFTP using SSIS here
February 23, 2012 at 2:00 am
Nested aggregates are not supported by direct line SQL queries. You might want to consider writing a CTE (Common table expression)
Please see here
January 10, 2012 at 5:19 am
January 9, 2012 at 10:14 pm
joe.heym (1/9/2012)
In your Connection properties set:RetainSameConnection = True
In associated Data Flow Task you may need to set property ValidateExternalMetaData = False
See the following for explanation and walkthrough:
Temporary and global tables...
January 9, 2012 at 3:18 am
Create physical tables to mimic the operation that you would want for the temporary objects. You can always drop the objects when no longer required.
January 8, 2012 at 11:01 pm
Or you can capture the events using event handlers and scripting the components that suit your need
January 8, 2012 at 9:43 am
you can have a package designed to automate the process
January 8, 2012 at 9:29 am
What protocol are you using?
FTP or SFTP? FTP task does not support SFTP
January 6, 2012 at 5:31 am
Viewing 15 posts - 121 through 135 (of 669 total)