SSIS can do this pretty easy with the export column transformation.

1. It depends on the connection manager used. This blog post explains it quite nicely:

Exploring the System.Object Package Variable[/url]

2. You can either iterate it using a for each loop (storing...

SSIS 2012 has two deployment models: package deployment model and project deployment model.

Package deployment model is exactly the same as SSIS 2008, so if you choose this model your migration...

Let's first state that I find this a terrible idea, but maybe you have a valid use case.

You can start an SSIS package either by calling dtexec.exe directly from the...

Nice question, thanks.

Great. Glad you got it solved and thanks for posting back.

Easy one, thanks.

Thanks for the question.

Nice question, thanks.

That's why the CONVERT function exists.

You might want to format the datetime a little bit differently.

Satu (11/6/2013)

---

In database engine I have sysadmin role but when one connects to Integration Services (instead of Database engine) Windows credentials are used. I have gathered that the packages are...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies:

http://www.sqlservercentral.com/Forums/Topic1511755-3077-1.aspx

You already have queries, so what's the question?

Odd. One would think a space and an empty string are not the same.

Thanks for sharing.

The data type of the variable should be integer.

Make sure you select single row result set in the Execute SQL Task.

If you want it as a date, I would cast...