Ciber2010 (3/22/2011)

---

Thanks, i need to keep sybase as my destination, so to work(support) on sybase ,which software i need to install.I heard that through "Rapid SQL" we can access sybase.Is...

jhgotla (3/22/2011)

---

You may want to try out the Merge statement. It is quite easy to use. It handles all Insert/Update/Delete depending on whether rows exist in the Staging and/or production...

Oh yeah, I forgot:

yet another alternative is to load the data from .csv instead of Excel. Less headaches!

Try setting the column in Excel to text instead of number.

Hopefully the JET OLE DB provider will read it in as a string and doesn't screw up the format.

If it...

Another option is to use the Synchronize wizard in the SSAS server.

http://msdn.microsoft.com/en-us/library/ms174928(v=SQL.105).aspx

You can't do that with out of-the-box SSIS.

The dataflow in SSIS is strongly typed about metadata, so you just can't dynamically add columns to your dataflow.

Alternatives are:

* use a 3rd...

If your column headings will stay the same, you can define them in the Flat File Destination. http://msdn.microsoft.com/en-us/library/ms188431.aspx

That way you won't have to write them yourself to the file and...

Nice question, thanks.

Nice question, thanks.

That is quite an amazing trailer. I...

No kidding? Exactly the same solution mentioned by the previous two posts...

Allright, glad that you found the solution. Thanks for posting back!

Apparently Gurusamy is half right. There is an option for SQL Command in the OLE DB Destination, SSIS just doesn't use it:

http://jessicammoss.blogspot.com/2009/02/ssis-insert-statement-using-ole-db.html

The link works perfectly here.

WayneS (3/21/2011)

---

It looks like there's quite a few of us jumping into this twitter thing all at once....