Can you run the batch file as an OS step in a job?

I was able to duplicate your problem on one of our 2000 baoxes. I don't have an answer for you unfortunately.

Have you searched the Microsoft Knowledge Base or reproted...

This doesn't look like a problem with PSFTP, but hat you have the encrypted (saved sensitive information) the package you are trying to run on your server.

Some people just have to complain. Good article. Jeff Moden also wrote an article on the Tally table here on SSC. If you haven't read it, you...

Matt Miller (11/24/2008)

---

There was a very similar thread to this a little while back. You might care to do a search using the SSC google search box (top right...

Now that was funny (lmao)

Looks like a variation on the running totals. I'd recommend two things; the first read the second article in my signature block, and two is use a properly constructed...

Sorry, but you posted your question in a SQL Server 2005 forum, so you got a SQL Server 2005 answer.

Jared Hunt - SQLAddict (11/24/2008)

---

SQL Server 2008 is not that much different than 2005 from an engine perspective, so I would be surprised if an app could run on SQL...

Read Books Online, specifically look up the PIVOT command.

vijaya (11/24/2008)

---

Hi,

When am trying to insert data in to tblAsset table using OLEDB dstination component in SSIS I got following error:

[db_dest_ins_tblAsset [26320]] Error: An OLE DB error has occurred. Error...

How do you have the numeric value defined?

Jack Corbett (11/24/2008)

---

Rod at work (11/24/2008)

---

Lynn, this is a very simple follow-up question, but I've got to ask it. In the one other SQL Job I've written I've got...

This is a unicode (nvarchar) string: N'tempdb..#test'

This, 'U', mean user defined table.

You can...

You may also want to look at the possibility of using indexed views.