Hi John,

CREATE TABLE [dbo].[Table1](

[Category] [nvarchar](max) NULL,

[EXCO] [nvarchar](max) NULL,

[UNIT Number] [float] NULL,

[Staffcount] [float] NULL

)

Insert Into Table1 ([Category],[EXCO],[UNIT Number], [Staffcount])

Values ('AD', '08', 4514, 60)

Insert Into Table1 ([Category],[EXCO],[UNIT Number], [Staffcount])

Values ('AD', '08', 8541,...

Hi Andrew,

Sorry I wasn't clear in my question. When I process that statement through SSIS, the OLEDB source executes successfully but the result is not sent to the destination

Thanks chris

that's it

Hi,

Thanks for the advise, It really helped to identify the problem. I was assigning the wrong value to the variable

Hi Jason,

Thanks for the feedback, the union transformation did the trick

Howard,

THANK YOU VERY MUCH. I was missing the quotes in my method. used that line you provided, it's working like a charm. now I'm going to try that other one...

Hi Howard,

Thanks for the feedback, I just tried your and it works fine. I would like to do this through a data flow task for so that I can move...

I have never used it before may you please post example

Hi Thanks for the feedback,

I have two execute process task that I need to get count from. the first one does compact and repair, the second one does archiving. I...

found a solution.

http://msbizoo.wordpress.com/2012/08/19/zip-utility-through-ssis/

Hi, Thanks for the response. I ticked traverse but it's still not picking the other file. now I'm trying to use a variable as a place holder for the file...

Thanks guys, it appears I don't have access to change those settings. I'll contact my admin.

thanks for the feedback

Thanks for the feedback I went with deleting and recreating the file and it worked fine. thanks everyone

Hi Guys,

I tried delete * from table_name, but I get this error :

[Execute SQL Task] Error: Executing the query "delete * from Data_Destination" failed with the following error: "Deleting...

Hi Howard,

Thanks, I got it right now and I managed to import the files.