Search results for query: *

Posts 24 How do I convert as/400 time field being seen as dt_I8 to string I am struggling getting a time field from as/400 into SQL 200 using SSIS. The time field for some reason is being seen as dt_I8, And every type of conversion I try to do with it, it gives me an error...

I figured it out. I had to set the AlwaysUseDefaultCodePage to True on the OLE DB Source component for your AS400 pull. Now on to seeing if I can figure out how to copy data now. SSIS is so much different than DTS. It's a learning curve for me.

Ok I figured it out. I had a paramter wrong. So connectioin looks like it is working. I now I can see the tables and when I test it works. But now when I select one of the tables as my source it gives me the following error. What does this mean and what do I do to resolve. TITLE: Microsoft...

Thanks for your reply. I think I know what your trying to tell me. Let me make sure. do a new connection within SSIS select my as400 name for server name key in profile/password. and set initial catalog to library I want. I tried this and hit test connection and it tell me test connetion...

I am trying to import data from our as/400 to SQL server. We have a new server with SQL 2005, data is restored so now I am trying to convert our DTS over to SSIS but I can's seem to get a connection set up that will talk with our as/400. One note on our current sql 2000 I have no issues. Our...

ok I found a little more detail on this message. I clicked on show techincal details and it gave me the following. I don't see anything here that tells me what is wrong. I though maybe it was my security on MSDB. I pretty much gave myself all roles with exeption of denydatereader and...

I have some DTS I have using the migration wizard to bring them over to SQL 2005. I have created a package and can sucessfully import them on the server but if i try to do it on my laptop I get a very generic error one or more errors occurred. there should be more specefic errors proceeding...

We are in process of migrating from SQl 2000 to 2005. We are doing a side by side since we have gotten a new server. I am working on imorting all my DTS over. I have used the import and saved them in MSDB like it was in 2000. Question on how to just view the package. From what I have read you...

I am in process of moving my SQL server over to SQL 2005. I am doing a side by side. I have restored it to SQL 2005. Most thing appear ok. Last night I set up a maintenance plan to re-index. It failed but gives no reason. If I view job history. I see where it starts re-indexing and re-indexed...

We have not tested it yet. WE planned on upgrading later this year. What type of db incapabilities exist between 2000 and 2005? Our db is used for datawarehousing. Basically we load up db from our as/400 every night with the transactions/data for the day vis DTS. Then reports are queried off...

We had the server our SQL 2000 db were on on fail. It doesn't look like we can get that server up an running quickly. So we plan on getting a new server for it. But temporarily we have another server that currently has SQL 2005 on it and installed. So I would like to restore db from tape and...

that would be correct. that is what I am trying to accomplish.

I have a table called Tmpstockledger that I am trying to update stockledger with. Ths issue is TMPStockledger has multiple records based on the join and its only updating with values from first record in TMPSTOCKLEDGER. How do I get it to update with both values. I'm updated a bunch of values...

Is there anyway to let a non sys admin see the status of a job running that they are not owners of without adding them to the sysadmin role? Everything I keep reading says they have to be in the sysadmin role in order to see the job status.

I am trying to install sql 2000 standard on a user's laptop. It has Windows XP SP1 on it. It's telling me that the operating system is not supported. Any ideas? Stacy

Can some one tell me why I am getting the following error when I run the below query: Error msg: Server: Msg 8624, Level 16, State 16, Line 1 Internal SQL Server error. Query: SELECT REPLACE(STR(dbo.Store.StoreNum,3),' ','0') + ' '+dbo.Store.StoreName...

yep I just found some statistics set up on these columns that probally got created with the auto update statstics options. I'm going to try dropping the statistics using drop stastics and then try altering the table after that. Thanks for your help. Stacy

I did the following query in enterprise manager: sp_depends weeklysaleshistory Results: Object does not reference any object, and no objects reference it. Which is what I would expect. I don't recall this object referencing anything else. Any other ideas? Stacy

I have a diagram with this weeklysaleshistory and have done show dependencies and its not coming back with anything. I do have an idenity column on this table. Could this be causing the problem? Stacy

I have a table in which I am expanding about 10 fields. I'm issuing the alter table commnand individually. I have expanded 7 of them suscessfully but the other 3 I'm getting an error. This is the command I'm using: Alter Table WeeklysalesHistory Alter column costofsales decimal(11,0) It...