Not really, this issue is something different and I searched all ssis forums for an answer before posting. Thanks.

Copy operation doesnt work for .mdb files/databases using File System Task, so how would one copy databases in the first place??

No thats not what i want, i can do most of the stuff myself all i need to know is how to make/create a .mdb file dynamically on the fly...

I already have a package that loops through different (ADO) objects and loads 3 different excel destinations dynamically, need to change excel to access destination dynamically so that it can...

Even if I create a new file each time using the template and file system task can the OLEDB Destination be dynamic enough to point to this newly created destination?...

Db2 version is 8.xx. Yes googled no luck. Need links to download the drivers to get this working. I have 64 bit windows OS on my desktop.

Please post links from where I can download this and whihc version i would need.

What is the order that needs to be followed? I have Year, Month, and Eight other parameters.

I tried to make Month cascaded from Year and the rest just multivalued. but...

My Destination column data type cannot be changed it has to remain numeric but i can make it to numeric(2,0) or numeric (3,0) depending on the source which has max...

Thanks for the reply.

Looking for more replies/solutions......

As posted earlier my input in source is of Char data type with values like 0,1,5,6, 12,14, 22.

My destination data type is numeric(1,0). Do i need a transformation at all.

As...

After converting from char to int in the source ,do i need to transform int to numeric using SSIS..if so, could you please suggest ssis type cast or data conversion...

The source table structure is somewhat like this

Create table call_fact(callfactid int, track_num bigint, optiondesc varchar(20),

tot_hold_time int , tot_talk_time int, distribution_type char(10),contract_id varchar(10))

Values for columns are like this

(13456723, 34567892, 345, 34,...