I just found this, let me try it and will let you know how it goes.

http://wiki.gieschen.it/doku.php?id=it:microsoft:ora64ssis

I'm just pointing out the things to look into, not saying thats the only way to do it, even if it might have sound like that:hehe:

- are you getting an error message?

- did you remember to add

using System.Data.OleDb;

at the beginning?

- did you try to debug and find out at which...

I was actually doing same thing last week, but instead of passing whole connection string i passed all the details in separate variables. Anyway i have a script task in...

Options -> Query Execution -> SQL Server -> General -> SET ROWCOUNT

Default value should be 0

What about a DDL trigger that would fire up on ALTER_PROCEDURE and if it is sp1 then inform about updating sp2. I can't think of other way at the moment.

I'm a DB Dev in a very specyfic eniviroment. Our company specializes in building stand alone QA/Process control machinery, that is shipped to customers factories and used there. every machine...

I use Ola's maintenance solution for backups (and more) on my SQLExress instances and can't say a bad word about it. just schedule a batch file in your windows task...

Looks almost exactly as the example under this link www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/[/url]

USE AAA

GO

create table A(

Rundate DATETIME NOT NULL DEFAULT(GETDATE())

,objname varchar(100)

,rows varchar (10)

,reserved varchar(10)

,data varchar(10)

,index_size varchar(10),

unused varchar(10))

Go

insert into A (

objname

,rows

,reserved

,data

,index_size

,unused)

exec AdventureWorks..sp_spaceused 'AdventureWorks.person.address'

Shame...

I might visit customers site, set it up and would like it to stay intact, the only way customer would affect the package is by using provided configuration file.

I was...

Bouke Bruinsma (2/23/2015)

---

I wouldn't dare questioning your or Gails remarks. But I could give many examples where a database is in full recovery mode without any backup strategy in place....

I'm going to get my 7 and 5 y/o their own first PC, nothing powerfull, just something to be able to watch movies and stuff on internet. Maybe minecraft will...

Thank you for help, it's working now!

In the article you've provided there is one thing i believe is missing, I couldn't find the step that would actually change the connection...

It looks like something i'm looking for! I'll give it a try and will let you know about the outcome. Thank you.