doh! thanks Seth;

I should have seen that, but wanted to let the OP know that he didn't need any fancy regular expressions, because it is supported to a degree in...

rereading, you might want to look at psexec.exe from sysinternals (now from MS):

http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx;

it is an administrative tool that can be used to run executables on other machines, regardless of...

it's kind of difficult, becuase the remote server would need to be able to login to the network in order to get to a UNC path to the batch file...

declare...

also, if you have a table with all allowable postal codes, you could simply join against it where the postalcodes not found, right:

--all invalid postalcodes

select * from yourtable

left outer join...

these are the once which are both alpha and have numbers: you can decide whether to delete or manually edit from this subset, i guess

select postalcode

from yourtable

--alphanumeric ANDALSO numeric

where postalcode...

replace "slash r" and "slash n" with the command that the forum obviously hates.

--the TSQL equivilent would be this command: note this assumes the table already exists,

and the number...

try this:

look in the registry in this path:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\DataProject

for this value:

SSVDefaultColumnType

change it from "nchar" to "varchar" or something, and see if that works for you.

for SSVDefaultColumnType

change it from 10...

Adding on to what Jack said, your sample data will help us visualize your FK structure...for example, maybe it sounds like OrderNumber is unique at the highest level, right? so...

i have a similar GEO database;

i have separate tables for countrytable ,province/region/state table , and city table.

my address table points only to the citytblkey; i don't bother keeping the statetablekey...

ok my issue was thinking owner=login=schema

this is what i had to do:

[font="Courier New"]

CREATE SCHEMA bob  AUTHORIZATION bob

CREATE SCHEMA jeff AUTHORIZATION jeff

CREATE TABLE bob.mytable(

TID INT IDENTITY(1,1),

mytext VARCHAR(30) )

CREATE TABLE jeff.mytable(

TID INT IDENTITY(1,1)...

in one of our accounting tables, we had a similar requirement where no update should be completed if someone updated the row prior toy you committing...

so if there was 20K...

isnt it true that for a linked server, you have to enumerate the columns you are inserting into?

i thought i tripped over that issue before;

INSERT INTO "Farmers Office Link"...report(col1,col2,col3)

SELECT *...

if the destination table has the eXACT same structure as the SELECt/DBCC, you do not need to mention the columns...since you added some extra fields, you have to explicitlu name...

the x is an alias; when you have a select in parenthesis, you need an alias in order to reference it;if you change the "x" to "mySubQuery" it makes more...

not sure with SSIS, as there's wizards to help you, but from a pure TSQL point of view,

with multiple sheets, you'll need to add the excel as a linked server.

once...