gugan_ta (12/14/2011)

---

We have planned to run the ssis packages using windows authentication.

Could you please suggest below steps is ok.

1. Source (SQL Server 1)

2. Stage & DW (SQL Server 2)

SSIS job...

Using DATEADD(ms,-3,expression) is sooooo SQL Server 2005 😉

Roy Ernest (12/14/2011)

---

You all are NUTS. I think I am the only sane person in the THREAD. 😀

I loved the comment about our resident Santa. 🙂 Brilliant but crazy.......

That's good advice.

I...

chhaya.porwal (12/14/2011)

---

thanks Koen Verbeeck,

i tried script from given link , but its file by file zipping the file i want all the file of a folder as one zip...

It seems you do not have the public class ScriptMain. Why not?

Try copy pasting your code into an empty script task, without deleting the class ScriptMain.

Great! Glad that you got it working. And now you can drink coffee instead of manually editing CSV files 😀

Look at the example in the article that I provided you.

If you use the ProcessInputRow(row) method, you are processing the data row by row. You just need to call the...

Indeed. That way everyone...

Allright, then you should be fine with the ForEach Loop with a FileSystem Task inside.

Depends on the region I guess. In my country, BI developers are quite in...

Dev (12/14/2011)

---

It’s safe if you didn’t crack any pants joke...

timotech (12/14/2011)

---

Good morning all,

Please i need help as per an issue, i want to insert some records from one table to another, the tables are the same structure, but...

What did you try? What were the errors?

You could use the Execute Process Task to call the Winzip executable. Use the correct command line parameters and it should be no...

With whole folder, do you mean all the files in the folder, or do also need to include the directory itself?

You can loop over all the files if you use...