mattward (12/9/2013)

---

I often have to import data from a CSV file into SIS. I have been doing this manually, using the Import and Export Wizard. I would like...

Is it writing the column names between every row or between every run of the process? If the data is not to be overwritten and you have specified putting...

Check the File System Task. It has a Move operation and there is an option to overwrite the destination.

Duplicate post. See the following thread:

http://www.sqlservercentral.com/Forums/Topic1509553-364-1.aspx

kl25 (10/25/2013)

---

I use an variable expression...

Ok, just noticed something in your image that I missed the first time. You've got Variable1 for holding a result set. But you've mapped it as a parameter,...

Not sure there's enough information here to help you troubleshoot this latest problem but here's one possibility for you to check. If this is the second package you've added...

What's the query? Has it been changed since you got the process to work originally?

What error are you receiving?

I use an variable expression for...

This thread might be helpful: Query for Continuous Period.

There are probably more elegant ways to do this but a method I've used is to:

1....

You might also want to check the following article by Gail Shaw about posting performance issues.

How to Post Performance Problems[/url]

I got a package created in SSIS 2005 (32 or 64 bit, I don't know). When I imported the package into 2008, I got several warnings, which I ignored. I...

Fairly lengthy discussion of various scenarios with adding dates and times:

Stackoverflow: How to combine date from one field with time from another field in MS SQL Server