Yes actually, when I go directly from Excel to SQL Server, I get an error stating that the data is too large for the field.  I checked and in every...

I checked the server that has SQL Server, no process running there.  I tried to have the network guys check the processes for the file/print server, but they have been...

The locking file should exist in the same directory as the Access database, correct?  I'll check the database to see if access is running.  I never thought of that.  Is...

Hey,

I did both of those, and still nothing.  I followed the suggestion that I found on another site, and save the DTS package as a VB file.  I looked at...

My tasks (in the order I want) are below:

1 Dynamic Properties Task

1 Execute SQL Task

4 Data Pump Tasks

2 Execute SQL Tasks

The execute SQL tasks update the data in the SQL...

Hey,

If using dtsrun or the DTS.library approach, you can store the file name in a global parameter.  Then use a dynamic task property to change the file name, and lastly,...

Excellent.  Thanks a lot.

Hey,

Sure, use the dtsrun utility to kick off a package (see books online), or use the SQL Server objects (DTS library).  The library needs the client installed.

Brian

Are you talking an HTML scraper, such as this http://www.dotnetjohn.com/articles.aspx?articleid=93.

Brian

Most likely, you will need a dynamic query; retrieve the column name from the query, then do

exec 'select ' + @Column + ' from TABLENAME'

I can't think of anyway other...

Hello,

Thanks for the reply.  What I want to do is:

I have about 160 procs.  I've used vbscripts to create the SQL, for example, this would be one script:

set statistics io...

Hello,

I would use a primary/foreign key in my design, but that is because user defined data types are discouraged where I work.  For character fields, I typically use null, but...

In C#, Boolean values are 0/1 for False/True

VB.NET has boolean values of 0/-1 for False/True

Just in case you wanted to know.  When integrating C# and VB.NET code, the CLR automatically...

Hey,

True, if your field is not a true/false type answer, then I wouldn't recommend bit; however, if a change is being requested to change to a multi-option answer, then that...

Hey,

Is there supposted to be more?  I don't see any output, or anything that was supposed to lead into the question?

Brian