1

Topic: SSIS call T-SQL in Data Flow

SQL Server 2012 R2, prompt as in SSIS a packet in unit Data Flow to cause own function or piece T-SQL?

2

Re: SSIS call T-SQL in Data Flow

OLE DB source

3

Re: SSIS call T-SQL in Data Flow

If function or the code return the data it is possible.
Are for this purpose used ADO NET Source, OLEDB Source or ODBC Source.
But normally it becomes in Control Flow.

4

Re: SSIS call T-SQL in Data Flow

At me, unfortunately, Flat File Source...

5

Re: SSIS call T-SQL in Data Flow

You are going to fulfill function to a file? What is that generally necessary?

6

Re: SSIS call T-SQL in Data Flow

SQL2008;
1) load a file in basis
2) apply to it the t-sql a piece

7

Re: SSIS call T-SQL in Data Flow

StarikNavy wrote:

SQL2008;
1) load a file in basis
2) apply to it the t-sql a piece

It not to me!

8

Re: SSIS call T-SQL in Data Flow

wrote:

1) load a file in basis
2) apply to it the t-sql a piece

Yes, probably and it is necessary to do through the intermediate columns.

9

Re: SSIS call T-SQL in Data Flow

Yes, probably and it is necessary to do through the intermediate columns of the table.

10

Re: SSIS call T-SQL in Data Flow

SQL2008 wrote:

It not to me!

)