packages are empty

Hello,
I have this problem on my SQL Server, when I go to local packages and open a
package, nothing shows inside it, when I execute it, it says that completed
successfully but no tasks are shown. I have to restart the whole computer
(Win 2K Server) inorder to see what is inside a package again, then after a
while or the next day, they redisapear.
Any help in solving this would be highly appreciated
thank you
Hi
Very strange. Have you opened the package on the server or on the client
workstation?
"M K W" <admin@.admin.com> wrote in message
news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
> Hello,
> I have this problem on my SQL Server, when I go to local packages and open
a
> package, nothing shows inside it, when I execute it, it says that
completed
> successfully but no tasks are shown. I have to restart the whole computer
> (Win 2K Server) inorder to see what is inside a package again, then after
a
> while or the next day, they redisapear.
> Any help in solving this would be highly appreciated
> thank you
>
|||I've heard of this when the dts dlls are not registered
correctly. Try reregistering the dts dlls or reapply Service
Pack 3.
-Sue
On Tue, 24 Aug 2004 09:51:06 +0300, "M K W"
<admin@.admin.com> wrote:

>Hello,
>I have this problem on my SQL Server, when I go to local packages and open a
>package, nothing shows inside it, when I execute it, it says that completed
>successfully but no tasks are shown. I have to restart the whole computer
>(Win 2K Server) inorder to see what is inside a package again, then after a
>while or the next day, they redisapear.
>Any help in solving this would be highly appreciated
>thank you
>
|||We have the same issue and if, as the previous poster asked, the
difference is only evident when connecting from a w/station, the
problem is in the build.
Not sure exactly what fixes it, may be re-application of latest
SP/patch.
Regards
ALI
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:<e0e$9faiEHA.3608@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
> Hi
> Very strange. Have you opened the package on the server or on the client
> workstation?
>
> "M K W" <admin@.admin.com> wrote in message
> news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
> a
> completed
> a
|||Hello Uri,
Thanks for your reply, I am opening the package from the server. I havn't
installed the latest SP yet, but I am afraid not to work too.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e0e$9faiEHA.3608@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi
> Very strange. Have you opened the package on the server or on the client
> workstation?
>
> "M K W" <admin@.admin.com> wrote in message
> news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
open[vbcol=seagreen]
> a
> completed
computer[vbcol=seagreen]
after
> a
>

packages are empty

Hello,
I have this problem on my SQL Server, when I go to local packages and open a
package, nothing shows inside it, when I execute it, it says that completed
successfully but no tasks are shown. I have to restart the whole computer
(Win 2K Server) inorder to see what is inside a package again, then after a
while or the next day, they redisapear.
Any help in solving this would be highly appreciated
thank youHi
Very strange. Have you opened the package on the server or on the client
workstation?
"M K W" <admin@.admin.com> wrote in message
news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
> Hello,
> I have this problem on my SQL Server, when I go to local packages and open
a
> package, nothing shows inside it, when I execute it, it says that
completed
> successfully but no tasks are shown. I have to restart the whole computer
> (Win 2K Server) inorder to see what is inside a package again, then after
a
> while or the next day, they redisapear.
> Any help in solving this would be highly appreciated
> thank you
>|||I've heard of this when the dts dlls are not registered
correctly. Try reregistering the dts dlls or reapply Service
Pack 3.
-Sue
On Tue, 24 Aug 2004 09:51:06 +0300, "M K W"
<admin@.admin.com> wrote:
>Hello,
>I have this problem on my SQL Server, when I go to local packages and open a
>package, nothing shows inside it, when I execute it, it says that completed
>successfully but no tasks are shown. I have to restart the whole computer
>(Win 2K Server) inorder to see what is inside a package again, then after a
>while or the next day, they redisapear.
>Any help in solving this would be highly appreciated
>thank you
>|||We have the same issue and if, as the previous poster asked, the
difference is only evident when connecting from a w/station, the
problem is in the build.
Not sure exactly what fixes it, may be re-application of latest
SP/patch.
Regards
ALI
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:<e0e$9faiEHA.3608@.TK2MSFTNGP09.phx.gbl>...
> Hi
> Very strange. Have you opened the package on the server or on the client
> workstation?
>
> "M K W" <admin@.admin.com> wrote in message
> news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
> > Hello,
> > I have this problem on my SQL Server, when I go to local packages and open
> a
> > package, nothing shows inside it, when I execute it, it says that
> completed
> > successfully but no tasks are shown. I have to restart the whole computer
> > (Win 2K Server) inorder to see what is inside a package again, then after
> a
> > while or the next day, they redisapear.
> > Any help in solving this would be highly appreciated
> > thank you
> >
> >|||Hello Uri,
Thanks for your reply, I am opening the package from the server. I havn't
installed the latest SP yet, but I am afraid not to work too.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e0e$9faiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> Hi
> Very strange. Have you opened the package on the server or on the client
> workstation?
>
> "M K W" <admin@.admin.com> wrote in message
> news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
> > Hello,
> > I have this problem on my SQL Server, when I go to local packages and
open
> a
> > package, nothing shows inside it, when I execute it, it says that
> completed
> > successfully but no tasks are shown. I have to restart the whole
computer
> > (Win 2K Server) inorder to see what is inside a package again, then
after
> a
> > while or the next day, they redisapear.
> > Any help in solving this would be highly appreciated
> > thank you
> >
> >
>sql

packages are empty

Hello,
I have this problem on my SQL Server, when I go to local packages and open a
package, nothing shows inside it, when I execute it, it says that completed
successfully but no tasks are shown. I have to restart the whole computer
(Win 2K Server) inorder to see what is inside a package again, then after a
while or the next day, they redisapear.
Any help in solving this would be highly appreciated
thank youHi
Very strange. Have you opened the package on the server or on the client
workstation?
"M K W" <admin@.admin.com> wrote in message
news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
> Hello,
> I have this problem on my SQL Server, when I go to local packages and open
a
> package, nothing shows inside it, when I execute it, it says that
completed
> successfully but no tasks are shown. I have to restart the whole computer
> (Win 2K Server) inorder to see what is inside a package again, then after
a
> while or the next day, they redisapear.
> Any help in solving this would be highly appreciated
> thank you
>|||I've heard of this when the dts dlls are not registered
correctly. Try reregistering the dts dlls or reapply Service
Pack 3.
-Sue
On Tue, 24 Aug 2004 09:51:06 +0300, "M K W"
<admin@.admin.com> wrote:

>Hello,
>I have this problem on my SQL Server, when I go to local packages and open
a
>package, nothing shows inside it, when I execute it, it says that completed
>successfully but no tasks are shown. I have to restart the whole computer
>(Win 2K Server) inorder to see what is inside a package again, then after a
>while or the next day, they redisapear.
>Any help in solving this would be highly appreciated
>thank you
>|||We have the same issue and if, as the previous poster asked, the
difference is only evident when connecting from a w/station, the
problem is in the build.
Not sure exactly what fixes it, may be re-application of latest
SP/patch.
Regards
ALI
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:<e0e$9faiEHA.3608@.TK2MSFTNGP09.phx.gbl
>...[vbcol=seagreen]
> Hi
> Very strange. Have you opened the package on the server or on the client
> workstation?
>
> "M K W" <admin@.admin.com> wrote in message
> news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
> a
> completed
> a|||Hello Uri,
Thanks for your reply, I am opening the package from the server. I havn't
installed the latest SP yet, but I am afraid not to work too.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e0e$9faiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> Hi
> Very strange. Have you opened the package on the server or on the client
> workstation?
>
> "M K W" <admin@.admin.com> wrote in message
> news:ewfg%23XaiEHA.1644@.tk2msftngp13.phx.gbl...
open[vbcol=seagreen]
> a
> completed
computer[vbcol=seagreen]
after[vbcol=seagreen]
> a
>

Package trasfer to remote server

I have developed my ssis packages on my local system.Now i want to move them to a remote server.I have connected to the remote server over vpn.Now how do i transfer them to the server.Once i transfer i need to make few changes to the connection.What is the best way to transfer and make it work.

And then i want to schedule the packages to run automatically.

Please let me know

My first suggestion would be to try to read some of the books on-line (BOL). However, barring that, you can transfer the packages in one of a few different ways depending on how it is that you would like to store them on the remote server.

1.

a) You can simply copy the package .dtsx files to a folder on the remote server (or any remote folder that the user account running the package has access to, more on that later).

b) If you are storing it on the msdb you would connect to your ssis server (follow the following link for more information on setting up the dcom correctly to allow you to connect http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx) and then click through the stored packages -> msdb and create a new folder, then right click and press import package. The rest should be pretty self explanatory.

2. What type of changes do you need to make? If they are simply connection string changes and / or variable changes you can use an xml config file, the /set values tab of the job step maintenance screen or the data connections tab (for changes to the connections). I would suggest the xml config file option. If you need to open the package and edit, you can easily do this (provided you set the correct package level protection, i.e. encrypt w/ password or do not encrypt sensitive, etc) by simply opening the package from the remote server.

3. See the following threads / technet articles on setting up a job / credentials / proxy etc.

http://support.microsoft.com/kb/912911

http://support.microsoft.com/?kbid=918760

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2068280&SiteID=1

Let us know if you have any more questions or need any more help

Package fails when it is scheduled

Hi
I'm using SQL Server 2000. I've created a local package which runs
fine when i execute it manually from Enterprise Manager, but
constantly fails when I schedule it. Can anybody suggest why this
might be?
Thanks
Colin
Most probably, its the permissions given to the userid that is used to
call the job.
either case, What does the history log say? (right click on the job
and select "view history")
On Mar 6, 5:52Xpm, Bobby <bob...@.blueyonder.co.uk> wrote:
> Hi
> I'm using SQL Server 2000. I've created a local package which runs
> fine when i execute it manually from Enterprise Manager, but
> constantly fails when I schedule it. Can anybody suggest why this
> might be?
> Thanks
> Colin
|||On 6 Mar, 23:56, schal <shivaramcha...@.gmail.com> wrote:
> Most probably, its the permissions given to the userid that is used to
> call the job.
> either case, What does the history log say? (right click on the job
> and select "view history")
>
The history log says the following:
Executed as user: SQLSRV01\SYSTEM. ...Start:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 DTSRun OnError:
DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error
string: The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 Error source: Microsoft OLE DB
Provider for ODBC Drivers Help file: Help context: 0
Error Detail Records: Error: -2147467259 (80004005); Provider
Error: 444 (1BC) Error string: The driver returned invalid (or
failed to return) SQL_DRIVER_ODBC_VER: 2.00 Error source:
Microsoft OLE DB Provider for ODBC Drivers Help file: Help
context: 0 Error: -2147467259 (80004005); Provider Error: 0
(0) Error string: Cannot find all files in data path Error
source: Microsoft OLE DB Provider for ODBC Drivers Help
file: ... Process Exit Code 2. The step failed.
The package has just three steps. Step 1 is an execute SQL task which
deletes from two tables. Steps 2 & 3 connect to our accounts package
(Sage) using ODBC and uses two Transform data tasks to copy data from
Sage tables to the two SQL server tables. I am connecting to SQL sever
using the Microsoft OLE DB provider. I know that Step 1 is working
because after the package fails the two SQL tables are empty.
The package works fine if I
|||On 8 Mar, 09:44, Bobby <bob...@.blueyonder.co.uk> wrote:
> On 6 Mar, 23:56, schal <shivaramcha...@.gmail.com> wrote:
>
> The history log says the following:
> Executed as user: SQLSRV01\SYSTEM. ...Start:
> DTSStep_DTSExecuteSQLTask_1 X DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_1 X DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1 X DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 X DTSRun OnError:
> DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) X X XError
> string: XThe driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 X X XError source: XMicrosoft OLE DB
> Provider for ODBC Drivers X X XHelp file: X X X XHelp context: X0
> Error Detail Records: X X XError: X-2147467259 (80004005); Provider
> Error: X444 (1BC) X X XError string: XThe driver returned invalid (or
> failed to return) SQL_DRIVER_ODBC_VER: 2.00 X X XError source:
> Microsoft OLE DB Provider for ODBC Drivers X X XHelp file: X X X XHelp
> context: X0 X X X X Error: X-2147467259 (80004005); Provider Error: X0
> (0) X X XError string: XCannot find all files in data path X XXError
> source: XMicrosoft OLE DB Provider for ODBC Drivers X X XHelp
> file: X X ... XProcess Exit Code 2. XThe step failed.
> The package has just three steps. Step 1 is an execute SQL task which
> deletes from two tables. Steps 2 & 3 connect to our accounts package
> (Sage) using ODBC and Xuses two Transform data tasks to copy data from
> Sage tables to the two SQL server tables. I am connecting to SQL sever
> using the Microsoft OLE DB provider. I know that Step 1 is working
> because after the package fails the two SQL tables are empty.
> The package works fine if I
.....right click on it and select Execute package. It only fails when
it is scheduled. Sorry, I got carried away when typing and hit the
wrong key!
Thanks for any help,
Colin
sql

Package fails when it is scheduled

Hi
I'm using SQL Server 2000. I've created a local package which runs
fine when i execute it manually from Enterprise Manager, but
constantly fails when I schedule it. Can anybody suggest why this
might be?
Thanks
ColinMost probably, its the permissions given to the userid that is used to
call the job.
either case, What does the history log say? (right click on the job
and select "view history")
On Mar 6, 5:52=A0pm, Bobby <bob...@.blueyonder.co.uk> wrote:
> Hi
> I'm using SQL Server 2000. I've created a local package which runs
> fine when i execute it manually from Enterprise Manager, but
> constantly fails when I schedule it. Can anybody suggest why this
> might be?
> Thanks
> Colin|||On 6 Mar, 23:56, schal <shivaramcha...@.gmail.com> wrote:
> Most probably, its the permissions given to the userid that is used to
> call the job.
> either case, What does the history log say? (right click on the job
> and select "view history")
>
The history log says the following:
Executed as user: SQLSRV01\SYSTEM. ...Start:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 DTSRun OnError:
DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error
string: The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 Error source: Microsoft OLE DB
Provider for ODBC Drivers Help file: Help context: 0
Error Detail Records: Error: -2147467259 (80004005); Provider
Error: 444 (1BC) Error string: The driver returned invalid (or
failed to return) SQL_DRIVER_ODBC_VER: 2.00 Error source:
Microsoft OLE DB Provider for ODBC Drivers Help file: Help
context: 0 Error: -2147467259 (80004005); Provider Error: 0
(0) Error string: Cannot find all files in data path Error
source: Microsoft OLE DB Provider for ODBC Drivers Help
file: ... Process Exit Code 2. The step failed.
The package has just three steps. Step 1 is an execute SQL task which
deletes from two tables. Steps 2 & 3 connect to our accounts package
(Sage) using ODBC and uses two Transform data tasks to copy data from
Sage tables to the two SQL server tables. I am connecting to SQL sever
using the Microsoft OLE DB provider. I know that Step 1 is working
because after the package fails the two SQL tables are empty.
The package works fine if I|||On 8 Mar, 09:44, Bobby <bob...@.blueyonder.co.uk> wrote:
> On 6 Mar, 23:56, schal <shivaramcha...@.gmail.com> wrote:
> > Most probably, its the permissions given to the userid that is used to
> > call the job.
> > either case, What does the history log say? (right click on the job
> > and select "view history")
> The history log says the following:
> Executed as user: SQLSRV01\SYSTEM. ...Start:
> DTSStep_DTSExecuteSQLTask_1 =A0 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_1 =A0 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1 =A0 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 =A0 DTSRun OnError:
> DTSStep_DTSDataPumpTask_1, Error =3D -2147467259 (80004005) =A0 =A0 =A0Err=or
> string: =A0The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 =A0 =A0 =A0Error source: =A0Microsoft OLE DB
> Provider for ODBC Drivers =A0 =A0 =A0Help file: =A0 =A0 =A0 =A0Help contex=t: =A00
> Error Detail Records: =A0 =A0 =A0Error: =A0-2147467259 (80004005); Provide=r
> Error: =A0444 (1BC) =A0 =A0 =A0Error string: =A0The driver returned invali=d (or
> failed to return) SQL_DRIVER_ODBC_VER: 2.00 =A0 =A0 =A0Error source:
> Microsoft OLE DB Provider for ODBC Drivers =A0 =A0 =A0Help file: =A0 =A0 ==A0 =A0Help
> context: =A00 =A0 =A0 =A0 =A0 Error: =A0-2147467259 (80004005); Provider E=rror: =A00
> (0) =A0 =A0 =A0Error string: =A0Cannot find all files in data path =A0 =A0= =A0Error
> source: =A0Microsoft OLE DB Provider for ODBC Drivers =A0 =A0 =A0Help
> file: =A0 =A0 ... =A0Process Exit Code 2. =A0The step failed.
> The package has just three steps. Step 1 is an execute SQL task which
> deletes from two tables. Steps 2 & 3 connect to our accounts package
> (Sage) using ODBC and =A0uses two Transform data tasks to copy data from
> Sage tables to the two SQL server tables. I am connecting to SQL sever
> using the Microsoft OLE DB provider. I know that Step 1 is working
> because after the package fails the two SQL tables are empty.
> The package works fine if I
=2E....right click on it and select Execute package. It only fails when
it is scheduled. Sorry, I got carried away when typing and hit the
wrong key!
Thanks for any help,
Colin

OWA over proxy server

Exchange machine uses local address. OWA is doing fine localy. But if i
wanted to make OWA available outside my company i had to do something. I
used apache server as proxy and in it i redirect all requests to internal
exchange address. Problem is tha users cannot login. I get response from
exchange but only logins make my life living hell.
Can somebody help me?
regards,
daliborSORRY WRONG GROUP
"Dalibor Cvijetinovic" <dalibor@.ice.si> wrote in message
news:%230RF1TMtDHA.2136@.TK2MSFTNGP10.phx.gbl...
> Exchange machine uses local address. OWA is doing fine localy. But if i
> wanted to make OWA available outside my company i had to do something. I
> used apache server as proxy and in it i redirect all requests to internal
> exchange address. Problem is tha users cannot login. I get response from
> exchange but only logins make my life living hell.
> Can somebody help me?
> regards,
> dalibor
>

Override Identity Column using Datatable

I need copy a table from a remote (hosted) SQL 2000 database server to my local machine. I don't have access to backups and am unable to correctly configure my local machine to add a linked server. So I plan to retrieve the data to a datatable, copy it in code and save it to my local server. But the table contains an identity column which I will need to insert the values manually so they match the original.

Can anyone tell me how I can set the datatable's save to use my manual values instead of the autonumber value?

Thanks.

there are two options

1. First remove the constraint on identity column, then import the data, after that apply the constraint on iidentity column.

2. Add another column for it,

|||

SET IDENTITY_INSERT {YourTableName} ON

INSERT INTO {YourTableName} ....

SET IDENTITY_INSERT {YourTableName} OFF

|||

Thank you for the response Motley, but I don't want to have to create SQL statements; I want to do this directly in code using a datatable. Do you know how to do that?

|||

If you do not want to write sql query, then I suggest to go for answer1, turn off identity feature, import the data and turn it on.

|||

You would use the "SQL Statements" I gave above in a sqldataadapters's updatecommand.

|||

Hi,

Actually the code is also calling the SQL statements to do the update. So you will always need some SQL Statements for updating.

I suggest you use the way Girijesh has provided. Turn off the identity contraint off and import data.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!