Lonnie Johnson (7/30/2009)

---

Is there a link or "walk through" that shows you how to set up a job to go to a web server, log on and get a file...

Try this:

( ( CODEPOINT( [COL1] ) >= 65 && CODEPOINT( [COL1] ) = 97 && CODEPOINT( [COL1] ) <= 122 ) ) ? SUBSTRING( [COL1], 2, LEN( [COL1] ) -...

tvanharp (7/28/2009)

---

We have a package with a web service task that ran on a SQL Server where the service account was a server admin.

Now it is being transfered to...

This doesn't look right. The easiest option would be to reinstall your server.

Yes, you can create a script to do it.

When you use the data flow task what happens?

Do you expect the XSD to change? If not check Keelio's XML Destination. Otherwise you have to create custom script component to build your output based on the XSD.

In the SQL Job Agent you have job execution log/history. You can review there what is the status.

So where does it find the information about aliasing?

sumankumarreddym (7/23/2009)

---

Hi

I am using SQL Server 2008 , trying to load the data from excel files into the sql server table.I have both the type of files i.e .xls...

DBASkippack (7/21/2009)

---

My SSIS connect string to Sybase is not recognizing the Sybase sql.ini entry alias... I am forced to use our actual 4-node server name to resolve. How...

Phil,

I could not stop laughing... so funny 🙂

Double-quote the variable like this:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"" + @[User::BudgetFilePath] + "\";Extended Properties=\"Excel 8.0;HDR=Yes\";"

Your path probably contains spaces.

Have you tried to setup your package in the remote server SQL job agent? And then use script to setup the remote server job step for execution.

This is duplicate post. The question is being answered here.