lduvall (12/10/2009)

---

I'm not getting the full UNC path. I'm just getting the name & extension. I've got the radio button checked that says "Fully qualified" but it's not bringing it...

[font="Comic Sans MS"]

Hello -

Aren't you getting the complete UNC path...

jagadeeshb (12/10/2009)

---

Hi,

Here actually i am getting the data from script and by using conditional split i want to verify the excact data with tab delimited and save those data into...

[font="Comic Sans MS"]

That is absolutely fine.

But how did you define the connection of the SQLSERVER your package...

[font="Comic Sans MS"]

Hi Jeirix,

See http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx for a visual help in case you have missed anything.

Try setting delayvalidation property of the task to be true and execute. If you...

[font="Comic Sans MS"]

The @[User::SourcePath] variable should look like this - "C:\folder1\logs\" an extra slash at end.

Now evaluate the DynamicPath as :

@[User::SourcePath]+ (DT_WSTR,4)YEAR(DATEADD("dd", -1, GETDATE())) + "-"

+ RIGHT("0" +...

[font="Comic Sans MS"]

Hi Jason,

Is the reject file format and source file format different for you?

If not - there is a quick solution - you can have a file system task...

[font="Comic Sans MS"]

Interesting question and I would love see any advise on this ...

[/font]

[font="Comic Sans MS"]

If this is allowed in your environment - system architecture - try using some text persing tool to get this done. I personally prefer using tools to do...

[font="Comic Sans MS"]

Anamika - one way to achive this is enforce a strong template for the excel sheet you are using.

It shows how you set the property of a...

jeirix (12/9/2009)

---

Hello guys, thanks for your examples. I had almost the same problem but I need to copy *.dat files from a folder that change the name every day using...

[font="Comic Sans MS"]

Delay validation has nothing to do with runtime performance - it just doesn't validate the component till runtime.

Did you check this : a detailed discussion on why...

[font="Comic Sans MS"]

Yes - this can be done.

Funny you asked this question - I was doing exactly similar stuff myself. Use expression to define the 'packagename' property. Use the...

[font="Comic Sans MS"]

Do you have any control over generating the recordset?

If yes - you can use a pseudo-column in the recordset - say setNum - and it would contain...

[font="Comic Sans MS"]

The DML/file structure is unclear to me.

But as I understand - powerful text parsing tools like perl would probably be best option for you . If you...