Search results for query: *

Hi, Question: in SSIS, what is the best way to create a dynamic Data Flow destination based on package-level variables? I need to extract data from one SQL Server (2014) instance, database, and table and import it into another SQL Server instance and database where the instance name and the...

Hi, I am somewhat new to SSIS. I have a need to create an SSIS package that creates a new empty database that will be populated downstream. I want to be able to pass the name of the new database to SSIS as a parameter. I have tried the following code in an Execute SQL task and it works...

I am working on a project for work using SSIS 2008. The package has a number of variables, some of which are passed in by reading from the SSIS config table, others are generated internally by my execution path. I am having problems troubleshooting this package and symptoms suggest that it is...

I have many years experience with MS-Access, but only recently started working with Access 2007. I am trying to "lock up" the database to keep users out of various things such as: - NavBar - Ribbon - VBE I used to use: Application.SetOptions "<item to set>", <value> I have tried...

thread961-1184247 and thread961-852677 -- I checked these and could not get the solution in them to work. I inherited a SQL Server 2000 database and I need to use DTS. In particular, I need to take a value that I store in the Parent Package's Global Variables and pass it to a Child Package...

I have a SS2K database for which I am writing a stored procedure. The procedure takes Table A containing a list of prime keys, joins it Tables B and C. Using a combination of data from these tables, it inserts data into the Target table. When it processes, I need to record the results as...

Works great ... Thanks! --- Tom

I figured out how to get the Prime Key by iterating the table indexes and testing the "Primary" property, then getting the index field/s. Now I am trying to determine how to get foreign keys. Has anyone seen information on retrieving foreign keys within a table using VBA? Thanks again! --- Tom

I am trying to use VBA to examine tables in an MS-Access to find Prime and Foreign keys. I know how to do it with SQL-Server, but not in MS-Access. Would anyone know how to do this in VBA? Thanks, --- Tom

MickeyJudd -- the post on P2P was almost correct. The person who answered was an old SS developer and was using the "+" sign (a SServer convention) vs. the Oracle "||" (double pipe symbols) to concatenate text strings. The correct answer is now there. Thanks! --- Tom

No ... it was a good answer. --- Tom

I am a SQL Server developer who is trying to to learn Oracle SQL. I am trying to write a query that will 1) determine the month number and if the number is 10, 11, or 12, will return '01-Oct-' of the current Calendar year. If the month number is between 1 and 9, it returns '01- Oct-' of the...

PS. I forgot to say that this is MS-Access 2003. [blush] Thanks! --- Tom

I did a search on this topic, but did not see much that helped. Here is my situation: I inherited a client-server application that has MS-Access (.MDB) as front-end and SQL-Server 2000 as backend. The developer used the backend only as storage (ie. no stored procedures, views...

I am using the Start (Date and Time) and the End (Date and Time) as DATES because I want to use date math to do calculations. A string would not work as well and involve a lot more overhead. --- Tom

I am working with tables from another application where the Date and Time data elements have been separated. Instead of the Access data type that includes both (e.g. 5/23/07 8:07 AM), the date is separated (e.g. 5/23/07) from the time (e.g. 8:07 AM) into two fields. The existing table records...

Remou, I am not so sure about that. I have saved .MDB files with breakpoints in the code. When I reopened them, they broke where the breakpoints were ... even though I could not see them. Go figure! I haven't figured out why, but I don't take chances anymore. Being able to use...

I am writing a utility to do some of the cleanup necessary for deploying our MS-Access applications in a standard orderly fashion. I have figured out how to disable the shift key, turn off builtin menus, hide the database window, and a few others. The only thing that I am having trouble with...

For your second question, are your checkbox values "mutually exclusive"? Example: Over age 18: Yes o No o where the answer can be either "yes" or "no" but not both. --- Tom

Thanks ... I'll give it a try! --- Tom