i believe you dont have ssis installed on your local machine....when install sql server 2005 on your machine i guess u havent checked thssis box may be that would...

i tried doing it opened the properties of the folder and clicked on security set the users to full access n tried but it didnt worked out i dnt know...

hey half but i know implemeted to excute a list of files froma folder but i couldnt understand what is exactly dng and ehat do u mean by if the...

hey frank can i know how can we do that using aggragate function ...bcoz we need to mention the distinct nid and the max of the other two columns so...

srry to interuupt what does it actually do ...

does he want to execute a bunch of files with .txt in a folder or ...make a list of files which are...

i have done that but i get some errors in this way ....

[Flat File Destination [162]] Warning: Access is denied.

[Flat File Destination [162]] Error: Cannot open the datafile "\\Syndevsql\rawdata\Schering\SP-MNYCC...

hey matt thats what i m dng now from source gave to other flat file dest and connected it on failure..but in flat file destiantion in the columns it shows...

hey matt n chuck i have an issue how should i redirect it in this case i have a problem with my source which is flat file so i have...

no its not the last row ...if its last row i culd have though of partial roa at end ...bit its not tat ....i checked it that was the row...

hey i m trying to do the same wty...

i tried doing that but still i get the same error...i couldnt do that i dont know why ??? but evrythng seems to be good....n i have other ques for...

the above reocrds gets imported but weh it gets to this file it gets the error i could nt know where the problem is

the datatype i gave is nvacrhar(50) ..the flat file for amt rebates is in this way .....

$15.23

$234.33

so i have the raw file in this way ...n the over all mpping...

go through the link [highlight=#ffff11][/highlight]if it doesnt make u clear let me know .......

http://www.sqlis.com/58.aspx

srry adam regd my previos post..As i started using ssis i thought of not using scripts that the reason i said that way nothing other than that thkz for...