It always is the simpliest of things that causes the most frustration.

Good luck with the rest of it.

Is this the same?

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/46d1df1a-ae95-432d-b6b3-baa88efdbfee/

Also in the 2005 forum there's this which seems to relate: http://www.sqlservercentral.com/Forums/Topic478084-148-1.aspx

.. local paths heh? Whatever next! :hehe:

As was told to me yesterday... it's a steep learning curve. :w00t:

You can also change the name and description of the object without going into the editor..

Select the object, then use the properties window. Under Identification you can set the names.

F4...

Also with Variables watch out for their scope...

They can exist globally in the package.. or within a data task. If you've declared a variable in a one data task and...

I am not saying it's the answer to all your questions, but there is a free tool call SQL Ping available from http://www.sqlsecurity.com. Comes in GUI and command...

From a quick google, you may have seen this, don't know if it will help you or not:

http://forums.asp.net/t/1200021.aspx

Ok edited... think I've missed the point... sorry

Hi Elliott,

I am still not sure exactly how we're going to be running the SSIS packages at the moment, we've got a production team who will be running the packages,...

Have the file source as a single columns, then count the number of column deliminators?

This is quite a good source for info:

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/08/handling-flat-files-with-varying-numbers-of-columns.aspx

Ok bad answer, more than likely... not done myself.

All activity would likely stay on the control flow area. There's an FTP task, a File System Task to move, copy, create,...

It's probably down to the complexity of the xml file. It's treating lower segments like children, or sub-tables as there could be many possible values for that part of the...

You can set the path of the file from an expression - which can include a variable...

I've not got an mdb connection setup, but principals should be the same as...

I really thought I'd love the use of the hierarchyid type... but things are slipping for me.. sorry if I am hijacking this a bit, but it's relevant.

I am finding...

Ok I've answered this one myself, but there could be better solutions.

I created a view on my table with the hierarchyId column as a string. i.e:

CREATE VIEW vwHier

AS

SELECT [Node] =...

And Reparent is now GetReparentedValue...

Good article, I am wandering myself about using this rather than the old child / parent id of past. One of the issues where I work,...