[font="Comic Sans MS"]

Sowmya - as Phil said - this is very much possible. Looks like your pathname would be same for a package. Your package needs to read the path...

[font="Comic Sans MS"]

I am sure there are many experts here who would be able to help you with script task - meanwhile you may wish to look here .. there...

[font="Comic Sans MS"]

I think choosing string is the correct way to go.. what is your destination table's data type?

[/font]

[font="Comic Sans MS"]

Sowmya

Sorry I couldn't understand the requirement. Please can you elaborate with an example? Like PackageA (localhost) -- PackageB (remote machine running thru sql agent) -- Excel Path...

[font="Comic Sans MS"]

Marios,

I was digging this through - can you check the link below if it is of any help?

http://social.msdn.microsoft.com/forums/en-US/vssetup/thread/13eafe4f-ff91-4d31-922a-71767c14d3b3/

[/font]

[font="Comic Sans MS"]

For the last scenario - refer here:

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

http://support.microsoft.com/kb/918760

[/font]

[font="Comic Sans MS"]

Hi Swaroop,

I think - the package is not being kicked off by SQL Agent. You would need to check this.

In order to be sure about this - you...

[font="Comic Sans MS"]

1) For my better understanding are you using the OLE DB/SQLServer destination with "Keep identity" checked?

2) This might sound very obvious - but did you check if any...

[font="Comic Sans MS"]

Phil - sorry -...

[font="Comic Sans MS"]

Hey - it was not a question - merely a statement as per my English...

[font="Comic Sans MS"]

Hi Swaroop,

Did you try adding logging? Can you see the package progress?

[/font]

[font="Comic Sans MS"]

Hello - you can use a derived column transform from the flatfile source and default the values to be NULL. Let me know if you need more elaboration...

[font="Comic Sans MS"]

Regarding first problem - here is a generic code snippet (courtesy Andy Leonard) - you can modify accordingly (or use as a whole) add a Derived Column Transformation...

[font="Comic Sans MS"]

1) Use books online ...

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

[font="Comic Sans MS"]

Hi,

You can use derived column to transform as required.

2nd problem first ..

Use replace string function to remove the space(s):

REPLACE([DateColumn]," ","")

[/font]