Sorry then but my best suggestion would be starting the walkthrough from the beginning in a fresh project. Compare your settings with the other developers that's working including service...

Okay, this is a bit tricky remotely but here goes.

Firstly, are you connecting to a SQL 2000 or SQL 2005 database ? If it's 2005 remote connections can be...

More than likely you're connecting using integrated security and the user context under which the web page is running is either invalid/null (the "double hop" scenario) or doesn't have access...

You have to download a third party zip program like http://www.7-zip.org or http://www.freebyte.com/fbzip/ and shell out from the package or write your own in .Net

If you're going to use SSIS I answered a similar question here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=291798

Instead of using a StreamWriter you could create an XMLDocument or XMLTextWriter which will enable you...

How are you persisting the generated xml ? I've never seen SQL Server generate the xml declaration and there's no way I can see of inserting it into the...

Just had another thought. When referring to variables you need to specify the Variables collection of the Dts object i.e.

Dts.Variables("User::XMLContent").Value

and not

DtsVariables("User::XMLContent").Value

as you seem to have done. Also...

Sounds very odd. I do think that the SSIS Visual Studio interface is a bit flaky and there's been a couple of instances where I've had to scrap packages...

I'm no SSIS guru but this is how I managed to do it

1. Create new package

2. Add SQL connection manager for server you're connecting to

3. Add Execute SQL task to...

My first thought is that you seem to be concatenating the path twice instead of the path and filename

i.e.

If System.IO.File.Exists((CStr(DTSVariables("ProductBuyListFileLocation").Value) + (CStr(DTSVariables("ProductBuyListFileLocation").Value)))) Then

instead of

If System.IO.File.Exists((CStr(DTSVariables("ProductBuyListFileLocation").Value) + (CStr(DTSVariables("ProductBuyListFileName").Value)))) Then

Also, there...

No, there is no built-in way that I know of to do this with For XML but you could enhance your query to look up the datatypes for your table...

I've just tried it in Management Studio and it seems to work fine. Just selected Flat File Source, set " as Text Qualifier, clicked on Columns, clicked the mouse...

SQL injection doesn't need to come from free text, it's pretty simple to create a bespoke HTML post simulating OPTION values containing whatever you want.

It's not a point that I...

Not that I can see. Also, you are right text/ntext datatypes can't be used for local variables but they can be used for stored procedure parameters. You could therefore...

nileshsane, I'd recommend using something like SQLXML and bulk loading the files if they are this size.