Any ideas on how I could get this task accomplished????

....

Depending on what you are calling changes - you might care to check out the "Schema changes history" report (available on right-click after you install SP2). It tracks DDL...

It's supposed to have the SQL Server 2K5 Full Capabilities talking about performance because what you do when you change compatibility mode is just to use the ANSI SQL 89...

The situation you describe is really strange for me :hehe: but have you checked other things like your firewall or your smtp server configuration??? You don't loose anything by checking...

hhhmmmm that is a weird error for me too :crazy: well for your first question I don't think your sql server compatibility level would be an issue here, because what...

Hi there, well first you should set your sql execute task ResultSet property to "Single Row" if you are getting only a row back like the max query you mentioned....

Well in order for you to be able to execute it or to see the package you just migrated, you have to connect to your Integration Services and you can...

why don't you try to export it to plain text file? so you could know what is getting or how is working :crazy: it is really weird I have several...

hi, I don't understand very well with question, but if you are gonna export your data to an excel spread sheet, you will have to create like the table that...

Greg Charles (5/21/2008)

---

Instead of building your own, you could use package configuration files to dynamically configure packages at runtime. Package configuration is a new feature of SSIS and...

I don't have any dinamic property in my dts and I am using SQL Server 2k5 version 9.00.1399 yeah which means I do not have a SP on my server...

I think the best way of doing it is with XML and making like a "installer" for your packages, so when you install this packages all the properties you decided...

But you should probably consider the consistency problem that you can get by using NOLOCK. If you are using it for reading tables that are not usually changing. I never...

Thanks for answering,and yeah I tried that and didn't work, I keep getting the same error:

TITLE: Microsoft Visual Studio

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

Error at DTSTask_DTSDataPumpTask_1 [OLE DB Source [1]]: An OLE DB error...

Hi Darran, I am actually doing exactly what you are trying to do. The only thing you need is to have the dts structured file and then you can "migrate"...