Thanks Phil,

Currently I use seperate jobs for each customer. However, when I change any config parameters then each job needs to be reconfigured.

Also I need to use dynamic column mapping...

Hi,

I am thinking of creating a column store index for the table i am using?

Is there any specifications for creating it?

Hi,

Got the Question solved from stackoverflow.

select * from (

select d.siteid, e.EventName

from (select e.siteid from tbl_data e group by e.SiteID) d

...

Hi Chris,

I am left joining the events table to the data table. The Left Outer Join is for getting the minimum event date so that i can get the days...

Hi,

Thanks for the solution. I'm getting the error

when i run the code you provided. However there is no...

Hi All,

I replaced the script task with a file system task and it worked.

Hi,

Thanks for your reply. I will check and update if the problem is resolved.

Hi Michal,

Tried your solution of creating Desktop in SysWow64...

However i'm getting the same error

Hi Michal,

Can you tell me why i need to add the folder to run 64bit mode?

How this is connected with my problem... Just to know the reason...

Also tell me how...

Hi,

I have the runtime 64 enabled as false.

I am using a proxy account for running the sql package.

Hi,

Both the source and dest dir are local path and is located in the same system the package is running.

The SourceDir is D:\SourceFiles\Pro001

and the destDir is D:\SourceFiles\Pro001\Archive

Hi

Thanks for the reply.

SO i need to download it from ftp and then only i have to read it right.

Hi,

Based on the discussion, I came to know that it needs to be a manual process. I found out a tool called sisulizer to get the translation done however that...

Hi,

Is there any way to do it in sql itself?

Are there any tools outside SQL that can be used for this?

Hi,

Thanks for your help.... I got the solution.