[font="Comic Sans MS"]

Sorry - couldn't understand the process. Can you please explain me further?

Are you executing T-SQL to get the data exported into excel ? Are you planning for any...

[font="Comic Sans MS"]

Yes - this is possible. You need to use excel destination and can use for each loop container to achieve this.

You can refer here:

http://msdn.microsoft.com/en-us/library/ms345182.aspx

[/font]

[font="Comic Sans MS"]

your expression doesn't look right to me.

what is your actual package name and msdb folder structure ?

[/font]

[font="Comic Sans MS"]

There is an excellent article on more generic topic "Sending scheduled SQL query results via HTML e-mail using SSIS" by Paul Clancy - you may wish to have...

[font="Comic Sans MS"]

file1 and file2 doesn't suffice - you should be specific....

[font="Comic Sans MS"]

Yes - you can use execute process task in order to do this. Go to process and you can specify the executable and the required arguments..

[/font]

[font="Comic Sans MS"]

Hello - you are right on track. Use string function .. findstring and substr ...

[/font]

[font="Comic Sans MS"]

Yes - using 7zip is very much convenient it's not only free and saves $$ - it supports large number of archive extensions and have some cool compression...

[font="Comic Sans MS"]

You can do the same using a script task within a for each loop container.. for the code you can google or refer here (similar code):

http://vbadud.blogspot.com/2007/12/combining-text-files-using-vba.html

or

[font="Comic Sans MS"]

Duplicate post - use http://www.oracleutilities.com/OSUtil/sqlldr.html

[/font]

[font="Comic Sans MS"]

setting session date format : Mon dd YYYY HH:mi:ssAM

REM set NLS_TIMESTAMP_FORMAT=Mon dd YYYY HH:mi:ffAM

REM set NLS_LANGUAGE=<insert the language of your database here e.g., US7ASCII>

REM...

[font="Comic Sans MS"]

Hi Norm,

1) Which version of excel are you using?

2) Which Excel connection manager are you using?

--

Also out of curiosity you please explain how are you doing these:

1....

[font="Comic Sans MS"]

Not talking about best practise or business requirement - but just in case - say "Learning Purpose" - if someone need to use temporarily table - there are...

[font="Comic Sans MS"]

as well ..

SET CONCAT_NULL_YIELDS_NULL ON

SELECT ISNULL('abcd'+NULL+NULL,'1234567890')

Results : 123456

[/font]

[font="Comic Sans MS"]

Hey Jags -

Not sure which one is your dd and which one is mm from your example 😛

Anyway here you go:

(DT_DBTIMESTAMP)(SUBSTRING((DT_WSTR,8)MyStringDate,1,4) +

"/" + SUBSTRING((DT_WSTR,8)MyStringDate,5,2)

+ "/"...