After step 2, you can also use a simple insert statement instead of following import/export wizard. this is only possible if you are running this statement on same server or...

Can you please upload sample data file?

can you please give a try as it happened with me once.

try

select * from [PROD].[database].dbo.

instead of

select * from PROD.database.dbo.table.

i know there is no difference in this but it...

it is really a pain to extract numbers from strings and even more complexity if the numeral standard is different from the standard one. i had done a project for...

it is entirely you choice. If it is feasible for you to move test files to common shared area, load with bcp or bulk insert and then move it to...

if possible try to run the DTS independent of a scheduled job in test environment.

or it could be that your exchange or mail is not setup properly in SQL...

Hi ecomkid

Check this based on your sample data.

DECLARE @Products TABLE

(product_id int

,OLDPictureURL VARCHAR(100)

, sku VARCHAR(100)

, NEWPictureURL VARCHAR(100))

INSERT INTO @Products (product_id, OLDPictureURL, sku)

SELECT 69, '~/Assets/ProductImages/1029351.jpg', 'IB-A3-12'

UNION ALL SELECT 70,...

Steve is right, you can set your default shema to user. For setting it default schema take help from link given below

http://msdn2.microsoft.com/en-us/library/ms176060.aspx

Hi Ken

I tried it and it works.

As it is stored in binary, even if i look at the data, i can't determine whether image is successfully loaded and when it...

Hi I have a script which i downloaded way back. Sorry i forgot author's name. But i pass on my credits to him if he finds this script.

i modified the...

I haven't dealt with this kind of situation, but if you can access data with openquery, i think there should not be much problem.

Why don't you try to store...

Hi Guys

I managed to do that, actaully just followed the image wizard.

The next problem i am facing is that when ever i export the file to pdf, every alternate...