October 22, 2008 at 10:04 am
Hello I have a query that generates a result set. when i want run the query within ssis, it give me the following error message:
Error at Data Flow Task [ItemUpdate [1]]: There is a data source column with no name. All data source column must have a name.
(Microsoft Visual Studio)
Which means that i have to name a column. is there a way whereby i can still create the required CSV file without a column name?
October 22, 2008 at 10:20 am
In your Flat File connection manager for the output file just be sure that the Column names in the first data row is unchecked.
😎
October 22, 2008 at 10:31 am
Hi there
do you know how i can configure the package to create an incremental file name each time it is dumped into the required locaton?
eg
file00001, file00002, file00003
October 22, 2008 at 10:38 am
Off hand, not really. I'd use the connection manager to name the file with a base name, then use a FileSystem task to complete the actual rename of the file. the steps in between to determine the final name of the file, not really sure.
😎
October 22, 2008 at 10:40 am
thats strange i thought the option of a variable can do that?
October 22, 2008 at 12:03 pm
How is a variable going to retain the last value from the previous run? You have to establish a process that ensures you get the next proper file name.
I know it can be done, probably using the For Each container combined with the File System Task.
Unfortunately, I don't have the time work out the exact process that I'd use in this case.
😎
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply