I have been tasked with creating an export from a mssql db which will contain
data and in addition have pictures filed in a directory.  Is there a way in
tsql to convert these image data types to jpg files?

When I export my data from SQL Server 2000 to Access, the Foreign Key
Constraints are not recognized and I must manually create them in Access. Is
it possible to convert them from SQL to Access automatically?
Any help would be greatly appreciated.

I have character data (money) that I need to convert to numeric data type.
When I use the convert or cast functions I receive, " Error converting data
type varchar to numeric." error.
I found that the character data contains credits with a negative sign.  Does

Thank for your help.
I need to export data from a sql table to a excel file but in the query I
want to use  parameters (start date and finish date) and this values I need
change. (prompt me to type)

I am making a DTS package that will import several columns from an
Excel spread sheet. I will be appending these imports to a table on the
SQL server. As the Excel spread sheet I get comes from several people
and are all named then same I need a time stamp each time the DTS

I'm using DTS to update an Excel file on a local drive and then FTP that
updated file to another server. The FTP process (an 'execute task process')
is set to begin 'on success' of the 'copy data' process and, sure enough, the
DOS window in which the FTP process runs doesn't fire ...

I have a DTS package and it will call a .exe file in Execute Process
Task. I need to catch the return code from the .exe after it executs.
However, the Return Code in Execute Process Task is what the DTS step
will return if it's successful. So how can I catch any retrun code from

I would like to provide our users a form inside our program to schedule a
DTS package. I.e. I am looking for an activeX or other API to the SQL server
agent.
I  cannot find any documentation.

How to execute dts from stored procedure?
How to use xp_cmdshell to evoke dtsrun?
I have the following parameters:
dts package name="myPackage"

I want to use Script Component in DTS 2005 to transfer data. But I don't have
any document or sample script to solve it.
Pls send to me some.
Very urgent, because my project maybe fail in next week.

I have a small project in which I have to import fields from a csv/xls file
and map it
to multiple tables within a database ensuring field validations and
referential integrity between tables, i.e. Insert/Update per the

I have a SQL Job that is calling a DTS package and the last 3 days I've been
getting a failure at the DTS step.  This code has run fine for many months.  
It says invalid character for cast specific (and overflow error).  The source
field is a date/time and the destination is a ...

Have 1 file each day with 4 or 5 record types.  Have 5 DataPumps, one for
each record type - 10 columns, 15 columns, 15 columns, 18 columns, 50
columns.  Each maps 1 to 1 to a table.  The last DataPump is only sent 2 days
a week, the others are sent everyday.

Hi, I am trying to importing data to my SQL Server DB using DTS but I am
getting errors. I don't have control over Orcale and looks like the errors
occur on DataTime fields. Here is the error message: "Error at Destination
for Row number 103299, Errors encountered so far in this ...

How to create multiple tables from single text file space
deliminted with variable within the source rows to create  
table.  Total of about 13 tables from single text file.
Michael Grant