Dynamic DBF Export
-
Can I dynamically loop thru and create dbf exports on the fly? I do this elsewhere for CSV, but can't get to it when output must be DBF. The connection (file name) for the DBF must change to match the new query.
i.e.
1 -Get source SQL, destination FileName from Execute SQL Task.
2- Setup and run query.
3. Export to FileNAme.DBF
LOOP
I know how to loop to #1, but changing the DBF output connection on the fly eludes me.
thnx
Randy.
-
Check the FAQ on setting connections over at http://www.sqldts.com
--------------------
Colt 45 - the original point and click interface
-
Actually, It's a transformation task issue.
If I loop thru and reset the DBF connection file name, the initial column transformation needs to be reset in the transormation task. For each loop I get new connection and SQL statement for Trans task, But need a way to call the 'Auto drop andredo coolumn transformation' method.
Randy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply