It's not a native solution, but you can create a library in VS and reference that assembly in your SSIS script task.

Could there be an issue with the Access runtime?  I'm not that familiar with Access, but I do know that Access applications use that runtime engine even if the data...

Steve, I don't necessarily disagree with posting blog data on multiple sites as you described (Personal blog = personal + career, career blog = just career), especially for less than...

You mention that the application's performance runs slow, but have you tried running the same query on the server itself in SSMS?  You can quickly rule out SQL Server as...

You can redirect rows in error to an alternate location, for example an output file for review.

hth

Tim

Regarding motivation -- I am a big fan of Scott Hanselman's Hanselminutes (http://www.hanselminutes.com).  He recently posted a great podcast entitled "How to be a better developer in 6 months",...

You're still operating in the Control Flow, which is just that - it controls the flow of the package but doesn't actually handle the data flow.  If there isn't one...

Not sure of how you could do this natively in SSIS, however you could probably get creative and invent a solution.  You can schedule a job to run at given intervals that...

Yes, every number would be distinct within a given set of data, but a number does not "belong" to a particular row.  If you pull the same query later, the...

If you are a subscriber to SQL Server magazine, there is a brief guide to getting started at http://www.sqlmag.com/Articles/ArticleID/96169/96169.html

hth

Tim

The new row numbering feature in SQL Server 2005 is very handy.  Just make sure that anyone who uses the data understands that it is only a row number and...

You're absolutely right Brandie.  Things you say and do tend to come back to you, whether good or bad.  The bridge you burn today may span the river you need...

So about this SQL DBA/HTML Developer/Particle Physicist position.  I meet all of the requirements except for the last.  Do you think they would allow me to learn particle physics on...

Having been passed over for a position on one or two occasions, I admit that the gut reaction is to bellow "why wasn't I good enough?".  However, now that I've been around the block...

It depends.  If you want to verify the entire file before processing, you are probably going to need a script task to run through the file and check each line.

If...