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...

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

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...

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 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...

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...

I am trying to use the SendObject method to send a report. I want to deliver the report as a snapshot attachment, however, I would also like to format what goes into the message body. My preference would be to use HTML in the body. Does anyone know how to do that? --- Tom

I access a number of external data sources, which unfortunately, download some numbers as text. I would like to write a macro to look at a worksheet, and either globally, convert "text numbers" to real numbers, or to have it go through, ID the candidate and let me choose "yes" or "no" to make...

I know that Excel allows you to create a file that retains all of your macros (PERSONAL.XLS) so that you can use them with all Excel sessions w/o having to copy the code into each spreadsheet. It also provides a way from Excel to create an addin which essentially works in a similar fashion. In...

I have a utility I am building to help with configuration control with various projects. I would like to be able to take any kind of file (text, .MDB, .XLS, .PPT, .DOC and do like I manually do in Windows Explorer. By manually right-clicking on the file, I select properties. When that is open...

In MS-Excel, I have a process in VBA where I have to do a CTRL-A, CTRL-C on a web page to extract some data to paste into an Excel spreadheet that I otherwise would not be able get (a given). I am able to clean it up fairly well, but there is one thing that I need to "error trap" ... that is...

I have an IE / Excel worksheet process that I am trying to automate via VBA. Manually, the process looks like this: 1) Run a web report to get results list. 2) Since there is no way to convert to MS-Excel, with the webpage in focus press CTRL-A, CTRL-C. 3) Select cell A1 in a blank...

I do most of my work in MS Access/VBA, but some of the work I do involves Excel/VBA. One problem I have had in BOTH applications is that on loading, some quirk of the operating system I have at work, the wrong "add-ins" (in MS Access; "references") get "linked". In simpler terms, my...

I am new to SQL Server 2000 Enterprise. I have a number of tables, views, sprocs, function, contraints, triggers, etc. defined. Now I am realizing that the names I chose for some fields were somewhat cryptic. Coming from the MS Access world, I am familiar with Speed Ferrett (c) that allows you...

Have a form with no recordsource, but several comboboxes that derive their datae from tables in a SQL-Server backend via ADO. I have several buttons that popup forms to edit fields in some of the tables that are sources to the comboboxes. When I return from the edited popup form, without fail...