Yes John.. That is the good Idea.

Thanks for your Reply.

Best Regards,

VijayVanamala.

I guys, I have achieved this using Slow changing dimension fixed attribute. If there is any other solution to achieve this please post the solution.

Thanks & Regards

VijayVanamala

Hi all,

It got executed..

The problem is with pivotkeycolumn in output column which should be defined correctly.

Check the column name and pivotkeycolumn properly. try to give the both names same...

Yeah.., thank you Koen for your support 🙂

Hi Koen,

Thanks for your suggestion, I have added another row in source query with other destination address and could able to export the file to multiple destinations ata atime.

Also, i...

Got Executed.., Changed the database table structure and then executed. Works fine now.

CREATE TABLE [dbo].[my_images](

[Image_ID] [int] IDENTITY(1,1) NOT NULL,

[ImagePath] [varchar](1000) NULL,

[Image] [varbinary](max) NULL

) ON [PRIMARY]

Check out the difference in structure...

Thank you for your support Will try

The Source data type is money. and the excel file is empty(it is a new excel file used as destination).

Can we change the data type in Database from money to...

Hi Koen,

No, am new to SSIS. am using adventure works database and there is no $ symbol in the source file.

I have used Data conversion and changed the data type...

HI,

If you are using 64bit OS, better do the following step

Right click on Project and select properties. select debugging and make Run64bitRuntime False.

also try to check Delayvalidation ( u...

Hi all,

I have found the solution. I used excel 97-2003 format i.e., .xls it is working fine.

as mentioned in the above mail.. check the properties make Run64bitRuntime(right click on...

Hi Experts,

I have the same problem., I used excel sheet as source to use cache transform and could not able to execute it. The same data works fine when using...