Thank you Phil

I remove to the root level of this particular forum.

Hello everyone,

I hope I'm in the right place here. If not, please let me know where I can post this question.

Here's my question:

With this call dtsRuntime.Package package = app.LoadPackage(Etl_package, null,...

Hi

very nice. Many thanks for the explanations.

One question: how can something be added later in the procedure?

Example:

a missing block:

BEGIN
  Insert Into Table_2(Field_1,Field_2,Field_3)
  Select field_1,field_2,field_3
 ...

Hi

I dont know if it works... but only try, Set the databasename.dbo.<your tablename> in your expression.

Brgds frank

Hi and good morning

Sorry but I dont know what is your goal?

Mayby you will insert something in IT?  Then use placeholder for it.

example: your @x variable has inside a  placeholder...

No, is'nt.

In this case, use to begin transaction SQL Statement.

Hi

First: Use in your SP Begin try and begin catch SQL Satements.

For eq.

Begin try

Update Tabelle

Set field= 1/0

Where field2=1

--here rais an error because Division durch zero

Ende Try

Begin catch

-- here you can...

Hello everyone,

this articles are over 10 years old.

Right now I'm asking myself the same question today; "How can I do this today?"

We use Outlook in the company and use "S...

Hi everyone

we are using Microsoft SQL Server 2017 Enterprise Edition in a cluster.

I also look for my dtsx packages in the msdb.dbo.sysdtspackages system table, but they cannot be found there.

Are...

• This reply was modified 3 years, 4 months ago by  frank.kress. Reason: Formating

Hi sqlGuru1day

nice username 🙂

OK. I had the same challenge.

The data was delivered almost similarly in the Excel sheet. But that couldn't be used for an automatic import (ETL).

The data must...

• This reply was modified 3 years, 5 months ago by  frank.kress. Reason: Formating
• This reply was modified 3 years, 5 months ago by  frank.kress. Reason: SQL Formating

hi everyone

Is there a solution?

brgds Frank

hi boehnc

what frederico_fonseca wrote is almost correct.

but the f.num field is defined as varchar or char, then the value may contain a comma.

Example: num = 12,123: if it was saved...

Hi Jeff

that's incredibly fantastic. That's exactly what I thought.

The system views such as: sys.sql_dependencies goes in the right direction but the tool from Quest is a real hammer.

And the link...

Hi Jeff fashions

thank you for your quick reply.

But unfortunately there is no one FK in this database 🙁

Only fields were joined together. These fields have no index and are not...

Yikes. Nobody uses REDGATE?
OK, another question: Which SQL Source Control should we use in the team?

brgds Frank