dtsx with config file?

Hi all

This is the situation: I've a dtsx package wich creates a tab delimited txt file from a sql server 2005 databasetable. Now this all works just fine. But what I want to do is that the user can choose the destination path of that created txt-file. Right now I've declared the path when I created the flat file source.

On the net I found that a config file for a dts package (sql server 2000 - Dynamic Property Task) could do the trick...

Any help plz?

thx!

There are a number of ways of doing this. You could use a configuration file but that would mean editing the configuration file each time and I don't think that's what you want to do.

You could change the value using the /SET option of dtexec.exe. Will that work for you?

-Jamie

DTS_E_COLUMNDATAOVERFLOWDISKIOBUFFER Error

Hi! I'm a newbie and I'm trying to create a SSIS package which would loop in a directory of comma delimited text files.

Could anybody help? I'm having a problem when I run my package.

[Flat File Source [524]] Error: The column data for column "IndicatorGroupID" overflowed the disk I/O buffer.
[Flat File Source [524]] Error: An error occurred while processing file "\\192.168.0.47\Temp\detail-2864EGGPUSH-20060315.txt" on data row 1.
[DTS.Pipeline] Error: The PrimeOutput method on component "Flat File Source" (524) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Please help...

:)

Try directing all erroring rows into into an error sink using the error output from your flat file source so you can examine them later. I imagine you have some erroneous data in there.

--Jamie

|||Thanks! I've already found the error. You were correct, I was not able to filter my loop. As it happened, it looped through all the files in the directory, even through the unparsed ones.I only needed it to loop through the parsed ones. Thanks again!