Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2008-07-16 : 21:41:28
|
| Hi all, How to call a flat file using a parameter and it should check for "Full.csv"? can any one please send me the procedure?-Thanks N Regards,Kanthi. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-17 : 01:40:29
|
| call a flat file? didnt get that. Are you trying to check if you've a file called full.csv and do some operation on it? |
 |
|
|
kkiranvr
Yak Posting Veteran
54 Posts |
Posted - 2008-07-17 : 02:38:17
|
| Now i have got one more doubt that, can we write a batch file to findout the "Full.txt"file names and run this batch file through SSIS package using Execture Process Task? If so can anyone give me the DOS commands how to find out the Full.txt file? and also please let me know what properties i should check for in Execute Process task?-Thanks N Regards,Kanthi. |
|
|
|
kkiranvr
Yak Posting Veteran
54 Posts |
Posted - 2008-07-17 : 02:48:21
|
| I want to more precise on the question....Here my scenario is, i need to grab a source file that contains "%Full.txt" files, now i need to fetch the file that contains "Full.txt" can we write a batch file to findout the "Full.txt"file names and run this batch file through SSIS package using Execture Process Task? If so can anyone give me the DOS commands how to find out the Full.txt file? and also please let me know what properties i should check for in Execute Process task?-Thanks N Regards,Chinna. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-17 : 03:35:20
|
quote:
Originally posted by kkiranvr
I want to more precise on the question....Here my scenario is, i need to grab a source file that contains "%Full.txt" files, now i need to fetch the file that contains "Full.txt" can we write a batch file to findout the "Full.txt"file names and run this batch file through SSIS package using Execture Process Task? If so can anyone give me the DOS commands how to find out the Full.txt file? and also please let me know what properties i should check for in Execute Process task?-Thanks N Regards,Chinna.
so you want find out all files which have names ending with Full.txt. this can be done with the use of ForEachLoop file enumerator and inside the loop you can use tasks to perform functions on files |
|
|
|
|
|
|
SSIS variables