Excellent,

Thanks to all!

Thanks guys.

Many thanks guys. Perfect!

Elutin,

I disagree. If you look closely, you will see that rows 1 & 2 for Table_A have the same File_Name value, similarly, rows 3, 4 & 5 (the clue is...

Hi,

I have resolved the issue. We had the 'Data access mode' set incorrectly.

It was set to 'xml data from variable' which we have now replaced to 'xml file from variable'.

An...

Hi Wayne,

Thanks for your reply

Unfortunately, I do need to worry about it, as the value (with double backslashes) fails:

ERROR: [XML Source [1]] Error: The component "XML Source" (1) was unable...

To avoid any confusion the [User::Location] variable was originally defined as \\pisces\ABN_Pub\siantec\samples

- The single quotes surrounding this value were just to demonstrate the start and end of the field.

If I...

Lutz - Thank you for your time and effort. (Unfortunately?) this posting was raised to pose several questions regarding change requirements focusing on 2 SQL tables, using T-SQL, so I...

Sorry if you felt that there was a lack of detail to my original post. I do appreciate your assistance.

One area that may have been not communicated correctly is the...

Hi,

Thanks for your help guys... The only thing is the 'Prepare' table does NOT contain a Test_Sequence column. I could include one but I would probably need the set a...

Hi,

I did try (I was putting my last response together whilst his reply came through) and it is just what I need. But its difficult to judge what to set...

Please see attachment. Hope it can be viewed ok.

Basically it shows the Loop through csv files (for each loop container)

The first executable object is Get File Name (Script Task) -...

Many thanks Dave,

I accessed the link you supplied and took on board your advice on keeping the File System Task within the same 'For Each Loop' container.

The process works fine...

Hi J.D.

That is spot-on! Althought the original link I posted was a huge help, your additional posting was exactly what I needed.

Many, Many Thanks,

It's Ok... I found out how to resolve this (I hope).

On the Import Wizard, there is a setting on the Column Mappings called Enable identity insert. Select this tick-box.

Microsoft definition:

Choose...