Regarding the first, I think the language barrier is creating some issue here for the OP (I...

robinrai3 (8/11/2011)

---

hi Mohammed/Jayant

thx for getting back so quick

Mohammed - remotely meant doing it by myself.. doing self study and eventually sitting the exam

Jayant -.Out of interest did you do it...

Using dumps to...

Nice question, thanks.

Great question, thanks.

Ninja's_RGR'us (8/10/2011)

---

Brandie Tarvin (8/10/2011)

---

Help me bug Microsoft about a minor issue that is driving me sane.

https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

This one is giving me heartburn. I almost ran something in Production that was supposed...

The Copy Column transformation well, copies columns :), while the derived column transformation can also copy columns, but also manipulate the data in existing columns using functions or generate new...

You can't configure the dataflow to be dynamic, at least not out of the box.

So you can do it with scripting in a .NET script task or using some tool...

The following thread seems to have some answers:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/deeba026-6be1-45db-b413-1969bbbe247b

😉

See my answer here:

http://www.sqlservercentral.com/Forums/Topic1157371-147-1.aspx

Put the SSIS package in a SQL Server Agent job and start the job using sp_start_job.

Or use xp_cmdshell to run the dtexec utility that will start the SSIS package.

Personally I...

I don't know if it will work, but you can try this:

http://www.select-sql.com/mssql/solved---retrieving-the-com-class-factory-for-component-with-clsid-in-ssis.html

Great question, thanks.

The Execute SQL Task shouldn't add characters, so maybe the query that you use in the task manipulates the data in some way?

That works when the double quotes are used as...