Search results for query: *

Are you closing the ftp connection? "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

How long does it take for that statement to return in query analyzer (or whatever the 2008 version is called)? "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

The server is hard-coded in the repository. You'll need to find the tables that have that and change them. I don't remember off-hand which one's they are - i think they have 'data' in the names. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

That was gonna be my next suggestion. Glad it works now. BTW, their scheduler is really lame. If you use SQL Server, it's much better to use that job scheduler and use the pmruncmd program to kick off the wf. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

What operating system - windows or unix? If windows, what account is the service running under? "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Have you ever run anything successfully in the scheduler? "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Not if it runs manually. Are you using versioning? And is the the first version? If so, did you check it in? "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Look at the session log. If there isn't one, then it means either the session or map is invalid. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Did you buy that option? It doesn't come with the standard version. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

First of all, how is GetZipcodesForDistance defined as a stored procedure? What database? Your definition looks like a subroutine. To assign the results to a dataset, you need to execute the stored procedure in a connection/command object and return the value to the dataset. You don't...

You can use the integration services (formerly DTS) to move the tables. If you have a lot of tables, maybe there's some 3rd party software that would take care of it. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

How many tables are involved? You say you have to use PowerCenter - then you will have to import the source and target tables and make maps to move the data between the servers. What version of sql server are you using? You might be able to do a direct connection between the databases and...

Sure. You will need code to do this. You'll have to use javascript on a button or link to open the word doc since you need it to run on the client. The user will need word on their computer. I don't have an example right now, but I can get one tomorrow. "I think we're all Bozos on this bus!" -...

That exception occurs when the value you put in the field containing the combobox isn't a member of the combobox. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Try using a datatable instead of dataset. It has the rows method. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

You're doing it fine. Just change the field retrieval to: dsLabelFields.Rows(0).Item("ShipToName") "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Yes, you need to use the update transform. Without it, PC thinks it's an insert. The update transform can do updates, inserts and deletes. Set the properties to DD_UPDATE to tell it to do the update. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Do you have an update transformation to the update target? "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

Check out the path class. You can get easily get the name, extension, path, etc. Path.GetFileName(file) will return the file name and extension without the path. "I think we're all Bozos on this bus!" - Firesign Theatre [jester]

The return value is for the number of rows affected by an insert, delete or update statement. Otherwise it's a -1. What are you trying to get back? "I think we're all Bozos on this bus!" - Firesign Theatre [jester]