Here is something that works on a simple one table problem:

[font="Courier New"]DECLARE @cities TABLE(zipcode CHAR(5), city VARCHAR(25), TYPE CHAR(1))

INSERT INTO @cities

   SELECT

       '85739',        'TUCSON',        'C'

   UNION ALL

   SELECT

       '85739',        'TUCSON',        'N'

   UNION ALL

  ...

Try changing the login option to "Be made using the login's current security context". I tried this using a basic SQL login that is only in the public server...

What are the properties of the oledb destination?

Could you post the steps you are using to import the data?

Are there any other processes accessing the table that the data is being imported into?

Wish I could understand exactly what it means too. I'm glad the update worked. I thought it might because it "changes" the values. A good blog on...

Thanks Gail. I guess that's my one new thing learned for the day, so I can go home now.

You need to wrap this:

bcp "SELECT getdate()" queryout "E:\BULKUPLOAD.dat" -c -U sa -P password

in a pair of single quotes like this:

''bcp "SELECT getdate()" queryout "E:\BULKUPLOAD.dat" -c -U sa -P password''

Remember...

Here's my first pass in T-SQL:

[font="Courier New"]DECLARE @table TABLE(DAY INT, Week INT, MONTH INT, Customer CHAR(3), PurchaseCount INT)

INSERT INTO @table

   SELECT

       1,      1,       1,        'ABC',           10

   UNION ALL

   SELECT

       7,      2,       1,        'DEF',            12

   UNION...

I'm assuming you already know how to get the file name into a variable and how to process it.

After processing the file use a File System Task with an operation...

You should be able to this pretty simply in SSIS, but without any example data and information about the fixed with sizes it is hard to give you any kind...

What is latex? I know it is a type of rubber, but I am assuming it means something else in this context.

Is the SQL Server setup to use Mixed Authentication?

By default only members of the sysadmin role would have rights within database when you create and then any logins you add...

I think you can use the ReportItems Collection. So the expression, using your example below, would be:

ReportItems!TextBox1.Value/ReportItems!TextBox2.Value

I had thought that in SQL Server 2005 the CLR was only .NET 2.0 compliant so that 3.5 assemblies will not work, thus no Linq availability. I could be...

There are several ways to do this in SQL and depend on if you are using a stored procedure or ad-hoc SQL. In a stored procedure I think the...