[font="Comic Sans MS"]As Phil Said :

" Please provide more information of what you are trying to achieve, with examples, and ask a question or two, obviating the need for readers...

[font="Comic Sans MS"]

Yes - this can be done using xp_cmdshell for sure. But that would be far complicated and you might face several issues with permissions etc ..

May I know...

[font="Comic Sans MS"]

Please refer to BOL for this - I think you...

vishal.kunwar (11/23/2009)

---

Hi All,

thanks for the response and i understood now how to use For each loop but my question remains the same.

how to work with date timestamp files, because one...

Ghanta (11/25/2009)

---

There is one issue though... They are historical files and each days files are in folders named as YYYYMMDD and the issue is somedays the files are Zipped while...

[font="Comic Sans MS"]

Hi Allen,

I think you have already checked this by writing the message in a flat/text file. If you are getting CR/LF properly there - you might need to...

[font="Comic Sans MS"]

For detailed...

[font="Comic Sans MS"]

You may also wish to have a look here :

An SSIS package does not run when you call the SSIS package from a SQL Server Agent job...

[font="Comic Sans MS"]

Dear SQL Learner,

There can be 2 approaches:

Option 1:

You can use a script task to determine if the file exists or not. You may use a variable fileExists to...

[font="Comic Sans MS"]

Hello - if you have used configuration through xml already - I assume you know how to put the database details in the xml configuration file.

Assume your...

Hello - while scheduling the package - are you storing into filesystem or MSDB?

[font="Comic Sans MS"]Hello - here you go :

http://www.lmgtfy.com/?q=SSIS+Easy+Package+Configuration

[/font]

[font="Comic Sans MS"]

Hi Maxer,

From description it's a little difficult to understand if you have missed something. You can check this out :

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

Did this help?

[/font]

[font="Comic Sans MS"]Thanks Steve - this video helped me a lot.[/font]

[font="Comic Sans MS"]Your are at wrong place..[/font]