When you create a new packages on the server it uses the current user as the owner. As Allen_Cui pointed out, you can do this using Save As...'.

Given that you...

I would use the method suggested by DAVNovak, much easier to understand all that is going on in the statement.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

Setup an on-demand job in SQL Agent. Then just have the user app execute sp_start_job to run the job.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface...

The first item you need clarify is how deep are the pockets? You can get some really handy tools, but they come at a price.

Second item is, how do you...

Yes, in order for SQL Mail to work you will need to use the domain account. This is because the LocalSystem account has no authentication to use Network resources. Also,...

Try the script without the ':'.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

What do you mean when you say you've 'configured a SMTP client in the SQL Server System'. Is this a third-party addition to the regular SQL Mail?

Hope this helps

Phill Carter

--------------------

Colt...

With the forthcoming release of SQL Reporting Services, I would hold off on doing too much developement and purchasing. From my first impressions of the product, I'd say that companies...

The staging tables would represent the data you receive each week. You clear and re-load them each time you perform a load.

Once you have loaded the staging tables it is...

Ok, now that I know what the data represents, I would recommend you go with Valdan's suggestion of two fields. This will give you the ability to show the data...

I generated a MSinfo32 report on my system here and it doesn't contain the text "System Name:". Therefore the script fails with an 'input past end of file' error.

Check the...

The problem is one of presentation. SQL stores the data in 18,4 format, padding out the zeros, so an entry of 12.10 results in 12.1000 in the database.

Hope this helps

Phill...

I'd start with your empty database first. Add all your foreign keys, indexes, etc..., this is your 'live' database. Then create another set of tables, these tables become your 'staging'...

You can do something similar but it would require a short ActiveX Script task before the ExecuteSQL task. This script would dynamically re-write the SQL of the Execute SQL task.

Here's...

If you don't need to import the ID from the spreadsheet then make sure you exclude that column in the transformations tab.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point...