So what you're really looking for is a document that will help you scam your way into a SQL Server job? Good luck with that....

Of course, there are lots...

Terrie, check the permissions on the D: drive - even though the account running the SQL Agent is a member of the local admins group, you can still have insufficient...

garyreeds (4/11/2008)

---

hi,

could you plz tell me what type of text file is this n why the ; is used at the end column.here is the attachment.

n when importing this file...

No, unfortunately you cannot deploy an Integration Services package to SQL Express or Workgroup:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Lookup_BI (4/10/2008)

---

Hi Tim,

I tried the code you have given above.Correct me if Im wrong, all I have to do is to add an output column in the script component, given...

Use a Derived Column transformation and create a copy of the column on which you want to match. When you copy the column, use the expression LOWER([original_column]), where [original_column]...

Create two data flows with a Success constraint between them. Use the first data flow for your Parent table; create an Excel Source and an Ole DB Destination and...

Yes, this is entirely possible by using a script component. When you create a script component, you'll notice an Inputs and Outputs window, which will allow you to create...

If you already have the SPs created, you will save yourself a layer of complexity by just scheduling the SP to run using SQL Server Agent. You can use...

I don't know of a way to specify a user id and password for a flat file connection.... since your source is a Solaris box, can you snatch the file...

Brandie,

If you are running the package on your workstation, the SSIS processing will happen on that machine (in most cases) instead of the server itself. At first glance, I...

'fraid so, Brandie. I just ran into this recently, and had to create a derived column on which to do my lookups. I'm trying to get some time...

I don't think you can do what you describe if you only use one control. Controls are rendered as a whole rather than character-by-character.

Is there any reason you can't...

Luke, I'm working through the Microsoft Press book entitled SQL Server 2005 Analysis Services Step By Step (0735621993). I'm pleased with the way it explains not only the "how"...

Without creating explicit connections for each file, I doubt if you can do them simultaneously. However, as the original responder indicated you can run them sequentially by using a...