Viewing 15 posts - 241 through 255 (of 334 total)
I never knew you could use a CASE statement in the ORDER BY clause! Wow! The number of complex SQL statements I can reduce (inherited from someone who knew nothing...
September 9, 2004 at 8:27 am
I've used the above technique (slightly modified below) lots of times for WHERE clauses. The ORDER BY clause is more difficult. If you just have SORT or DON'T SORT and...
September 9, 2004 at 5:06 am
Take a look at the SQLDTSFTP Custom FTP task at http://www.sqldts.com/default.aspx?272
I haven't completely reviewed all the features, but it does provide a more complete interface to FTP. It may...
September 7, 2004 at 5:42 am
I know this is an old thread, but I was searching for anyone with similar problems hoping someone has a resolution. The problem is described here:
September 2, 2004 at 9:15 am
I believe (and I may be wrong...) that the square brackets are required for any name that matches a reserved word (i.e. "user") or has special characters, including blanks (i.e....
July 7, 2004 at 5:02 am
On import if you have empty strings and you want them represented as NULL in the database you'll have to code a transformation formula that tests the source field for...
July 6, 2004 at 5:06 am
The best approach if there's a lot of data and the distribution of table names is large and not always sequential would be to combine records n and n+1 into...
July 6, 2004 at 5:01 am
Use a SQL Task with a Truncate Table tablename statement. Using the option to delete records in the transform data task will use a "Delete * From tablename" which, if...
July 6, 2004 at 4:52 am
I appreciate the start. I understand the issues, I've used DBCCReindex before. I've been following this post: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=120908
and the (current) last post in the thread makes an argument for...
June 22, 2004 at 4:14 am
I have that question in to the SQL SA group. They may have changed something and not told us...
I'll keep everyone posted.
June 17, 2004 at 5:12 am
All good ideas. All things I've tried. The problem happens with two similar packages on different SQL Servers. It happens from various client platforms including both XP and Win2K. I've...
June 16, 2004 at 10:54 am
All my paths to the flat files use full UNC paths (\\server\share\directory\file.csv).
I also tried going to the machine on which the DTS job runs and using standard Windows paths...
June 16, 2004 at 8:01 am
Additional Info:
I went back to one of the steps in the existing job flow that runs successfullly every night and when I click on the Destination tab of the Transform...
June 16, 2004 at 5:27 am
If the purpose for producing the cross-tab is to generate a report then most reporting tools (SQL RS or Crystal) will produce the cross-tab for you. YOu can even pull...
June 4, 2004 at 5:08 am
It wasn't the MS reported problem.
I finally broke down and bulled my way through it by changing all the "," to !!! and then all the "<crlf>" to !!. Then...
May 26, 2004 at 12:41 pm
Viewing 15 posts - 241 through 255 (of 334 total)