sqlquest2575 (7/5/2011)

---

below are the queries which errored out--- I changed the distinctrow to distinct and as function to Function_1 and that corrected the syntax and after these changes the...

Yes but you will often encounter commas in text...

Are you referring to the 64 bit edition?

http://stackoverflow.com/questions/3086980/how-to-enable-utility-control-point-in-sql-server-standard-edition-64-bit

Thats great that you solved it.

Adding break points, using the Immediate, Locals & Watch Windows and stepping through you code make it easier to debug your code. 🙂

Yes you can but you have to enable cross database ownership chaining which is a security...

Are you going to post your solution?

Good deal.

Try using a delimiter another than ",".

You can use "|" but I had a situation where someone placed a Pipe in the text which caused the job to fail.

So...

xXShanXx (7/4/2011)

---

Hi

I have to call the stored procedures and i have to populate it on a temp table and my stored procedure will access the temp table

can any...

I'm not sure...

CREATE TABLE CITIES (

ccode varchar(200) NULL,

[city] [varchar](100) NULL,

[rcode] varchar(200) NULL,

[iguid] [uniqueidentifier] NULL,

[uguid] [uniqueidentifier] NULL,

[rguid] [uniqueidentifier] NULL

)

Conternts of TxtFile3.txt

ad,Aixàs,06,,,

ad,Aixirivali,06,,,

ad,Aixirivall,06,,,

ad,Aixirvall,06,,,

ad,Aixovall,06,,,

ad,Andorra,07,,,

ad,Andorra la Vella,07,,,

ad,Andorra-Vieille,07,,,

ad,Andorre,07,,,

ad,Andorre-la-Vieille,07,,,

ad,Andorre-Vieille,07,,,

ad,Ansalonga,04,,,

ad,Anyós,05,,,

bulk insert cities

from 'C:\SSIS\TxtFile3.txt'

with

(

fieldterminator = ',',

ROWTERMINATOR = ''

)

(13 row(s) affected)

SELECT *...

I would recommend using a pipe "|" for your row terminator. If you have a comma in your text it messes up the load.

You row terminator is not being recognized.

HTH.

There is a syntax error with your CREATE TABLE Statement.

Also you have a syntax error on your Terminators of your Bulk Insert.

A training video on setting Database Mail. The volume is not very good.

Perhaps you missed something.

http://sqlserver-training.com/database-mail-sql-server-2008-video-tutorial/

I'm not positive what you mean for it could be interpreted different ways?

Can you send an email without an...

It would be a combination of the entities and the logic to track the quantity on Hand, etc.