Hi everybody I wanted to convert all my csv format files into Excel format from a particular folder. After conversion of csv to excel, it (csv) has to be deleted from that folder. Did anyone face this task earlier? If yes, kindly let me know how to do or it would be better to send me a sample package...

I have an SSIS package setup to check for XML files from a specific folder on an FTP server. The first Task is an FTP download and copies everything to a local directory. Then I setup a ForEachLoop container on the directory to iterate through all the downloaded files. The first thing I want it to do...

Dave, Use this query to obtain the information you are looking for: SELECT [dts].[name] [package_name], SUSER_SNAME([dts].[ownersid]) [package_owner] FROM [msdb].[dbo].[sysdtspackages90] [dts] ORDER BY [package_name]

Hi, I need to load data into a table from a flat file. The last row in the flat file contains information about the total number of rows in the file. Is there a way to read the last row in the flat file and match the number of rows that are loaded into the file. I want to make sure that all the rows...