Without more details, I'd build a prototype job that looked something like this:

IF EXISTS(SELECT STATUS FROM SOMETABLE WHERE STATUS='READY')

BEGIN

SET XACT_ABORT ON

...

Karthika Raman (1/17/2008)

---

I will not be able to control the entire process through SSIS. The migration tool cannot be controlled through SSIS. So given that I have to...

i put to gether the table and data, but didn't have time to continue; this might help in the analysis:

create table #SpreadSheet(

Zip varchar(9),

City ...

see this page for someone else who had the same issue:

http://www.sqlservercentral.com/Forums/Topic419269-146-3.aspx

there is a function called Propercase in the script contributions section.

with that function installed, you could then simply do an update:

UPDATE SomeTable

SET NameColumn = dbo.Propercase(NameColumn)

Proper Case A String Or...

we had to maintain level 80 compatibility for a while;

tracing the application, we found that some sql statements which you could get away with in 80 fail in 90;

specifically it...

a function is a special, more limited type of stored procedure. it is specialized, so it has more limitations.

here's some high points, but there's a lot of infor to google...

select * from sysindexes where name like '_Wa_Sys%' in sql 2000 or 2005.

SQL server collects statistics on every query you run....those statistics can be used to determine whether a...

I'm properly chastized for talking without testing...

my answer is appropraite for WHERE statements, but not a replace...

LIKE '%%%%' would be where a percent sign exists in the data, for example.

two of the same character in a row is the escape for any special character in sql:brackets, percents, single quotes, etc.

replace(somecolumn,'%%','') to get rid of a percent sign, if it...

maybe i read your attachment too quickly, but i didn't see a worksheet with the data, only the sheet with the column definitions.

if there was a worksheet with just data...

ok, The command line you pasted does make it a little clearer...and I'm going to guess that the issue is still permissions;

hrggrouper.exe

-i D:\PCT_Warehouse\LoadFiles\GrouperFiles\AEGrouperTemp.csv <--input file i...

you could also do the same thing with a calculated column in Excel:

=IF(E3="N",B3 & " DECIMAL("&F3&","&G3&"),",B3 & " VARCHAR("&D3&"),")

that would return this for the fiurst column:

YPNO DECIMAL(8,0),

i just took what i thought were the relevant columns, pasted them in editPlus, and then ran some find and replace macros agaisnt it...I assumed AlphaNumeric columns were varchars,...

there's a similar thread where someone needed to generate the same kind of random sample...read matt Millers example here: http://www.sqlservercentral.com/Forums/Topic427826-338-2.aspx you'd change just the portion that did TOP 1000000...