Hi

you can schedule the job which will execute after every 1 hour to synchronise database.

For synchronising as Lowell has suggested, a trigger can update date column or a flag which...

You can validate file level attributes through script task or system file task. Data validation might be very time consuming through script task.

I use following approach for similar kind of...

Hi

you can use impersonation at your application level connection string. and grant access on ALL DB objects for that windows user only. NO other windows authenticated user should have access...

Paul, I agree that generating SSIS at runtime through .Net code is not an easy task.

My second solution is comparitively easier one. Challenge with this solution can be source...

There will not be any straight forward way of doing it. I can suggest few options:

1. Write a code which will generate an Export package for you at runtime and...

There will not be any straight forward way of doing it. I can suggest few options:

1. Write a code which will generate an Export package for you at runtime and...

I think you need to look into destination connection properties and check configuration for row seperator. Somehow I think issue is with row seperation than data conversion.

hi

Take a "Execute SQL Task"

Give you SP Name as input to SQL Command object. type question marks as placeholder for your parameters.

In second tab, you can map your parameters through...

RowCount transformation gives row count which are passed through that transformation. That is if 50 rows are transfered then after transfer it will set CountVariable =50. It will increment with...

Hi

Have you tried data conversion task? here you can convert source value to signed integer. You may need to update your destination column type as well.

OR

You can set up...

One more thing you can try..

go to Source Data Flow tasks and open it.

It has property to Retain Null Values.

Thanks,

Rupashri

Hi,

When you complete IMport Ecport Wizard, it asks you to save the SSIS package. Check that option.

Open this SSIS Package in Business Intelligence Studio. Right click on "SourceConnection"->Edit. Go to...

Try this:

1. Go to SQL Server Agents\Jobs. Select job and click Properties.

2. Go down to Steps

3. Highlight your SubPlan and click Edit

4. Add a Backslash to the beginning of...