May 19, 2012 at 1:14 pm
Hi,
My src is a flat file .I want load the columns count load into one destination .How can do this in ssis?
May 19, 2012 at 6:00 pm
Your question is not quite clear.
Do you mean you want count the number of columns in your flat file and load the result to destination?
May 20, 2012 at 10:57 pm
You can use unpivot transformation and row count transformation to get this done.
May 21, 2012 at 10:31 pm
Hi,
Yes
May 21, 2012 at 11:22 pm
The SSIS dataflow can't handle changing metadata, so the number of columns should be fixed.
Ergo, you should know this number upfront.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 23, 2012 at 7:58 am
Hi,
Yes the number of columns are fixed but we don't know how many there?that we can find without open the package/preview this?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply