Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: sqlserver
163 results found
Programmatically Import Flat File Data Source into SQL Server 2008 Using SSIS’s Script Task Tool
This article demonstrates creating a SQL Server Integration Services package that imports a text file into SQL Server database table using a Script Task component
Author:
mafiswana
Date: 3/25/2012 Section:
Article
tags :
C#
,
create package
,
C-Sharp
,
Data Flow Task
,
dynamic
,
Flat File
,
OLE DB
,
OLE DB Destination
,
package
,
programmatic
,
script task
,
SQL Server
,
SQL Server 2008
,
SQL Server Intergration Services
,
SSIS
,
SSIS package
,
Text File
Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#
SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. In this article, I will demonstrate the scripting of Integration Services Catalog packages using C#.
Author:
mafiswana
Date: 8/14/2012 Section:
Article
tags :
CatalogFolder
,
Create SSIS Package
,
Managed Object Model
,
Microsoft Visual C# 2010
,
Microsoft.SqlServer.Dts.Runtime
,
Microsoft.SqlServer.Management.IntegrationServices
,
Microsoft.SqlServer.Management.Smo
,
SSDT
,
SSIS 2012
,
SSIS Catalog
,
Visual Studio 2010
Group Filter impact on Aggregate
It is possible that I don't completely understand your issue. It is sometimes hard to tell unless in front of the problem itself. At any rate, I was so inspired by this post, that I wrote a blog about it. You can see it on SQL Server Central http://www.sq
Author:
briankmcdonald
Date: 4/12/2011 Section:
Forum
tags :
Aggregating Thresholds
,
Brian K McDonald
,
Reporting Services
,
SQLBIGeek
,
SSRS
Create Access 2010 File
With which version of SQL are you trying to build this? Are you going the 32-bit or 64-bit route? Which version of Office do you have installed and are you trying to use the ACE drivers? I have about an hour later in the day - I'll try to set up a test an
Author:
KeithHyer
Date: 1/26/2012 Section:
Forum
tags :
accdb
,
Access2010
,
ACE
Limit Report Results Based on User Logon
Actually this is possible and somewhat easy to implement. You'll just need to create a lookup table (UserCustomers or whatever your naming convention dictates) with user_id's (username) and customer_id's. Then when you use any table that has customer_id,
Author:
briankmcdonald
Date: 2/16/2011 Section:
Forum
tags :
Brian K McDonald
,
Filtering Results Based on UserName
,
SQLBIGeek
,
Reporting Services
Load XML Data into SQL Server
I believe you want to use a data flow and conditional split transforms to achieve routing your NULL rows to a different table and not the Data Profile task. I believe it's just for a developer to profile data in the viewer so you know what your source dat
Author:
m3crast
Date: 5/4/2011 Section:
Forum
tags :
2008
,
control flow
,
ssis
,
data profiling task
export to xlsx
I haven't tested this method, but I started to look into this a while back - this link might help you out: http://blogs.msdn.com/b/mattm/archive/2010/04/05/exporting-to-excel-2007-xslx-vs-xslb.aspx I believe the solution here is all about the way you set
Author:
KeithHyer
Date: 11/16/2011 Section:
Forum
tags :
2008 R2
,
excel destination
,
xlsx
Help on installing the SQL Server 2012 integrated along with SharePoint 2010.
Hello BIDN Family, After long time gap, I just want to post a blog that might be helpful to the one who is going to learn, try and setup these great products of Microsoft as SQL Server 2012 and SharePoint 2010. If you are going to learn, try and install S
Author:
Anil
Date: 4/24/2012 Section:
Blog
tags :
Sharepoint 2010
,
SSRS
Find Table Heaps Using Policy-Based Management
This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already use Twitter, the SQL Community has setup a great resource on there using the hashtag of #sqlhelp . Today a conversation came up due to a forum question ove
Author:
sqlchicken
Date: 4/8/2011 Section:
Blog
tags :
administration
,
pbm
,
policy-based management
,
dba
SQL University: Architecture for Small Businesses
Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at a high level ( Capacity Planning Week ) but this week we’re going to get a little more focused. SQL Se
Author:
sqlchicken
Date: 9/19/2011 Section:
Blog
tags :
administration
,
Architecture
,
azure
,
Cloud Computing
,
Licensing
,
SQL Azure
,
sql university
,
sqlu
Fast Track Presentation Slide Deck and Resources
Thanks to all who attended the Implementing the SQL Server Fast Track presentation this week. If you missed it, you can see the recordings here: https://www1.gotomeeting.com/register/933664848 or download the slides her: http://www.bidn.com/Assets/Uploade
Author:
BrianKnight
Date: 6/30/2010 Section:
Blog
tags :
sql server 2008
,
webinar
,
sql server fast track
Download a free copy of Microsoft Press eBook ‘Introducing Microsoft® SQL Server 2012’.
Hello BIDN family, After a long time gap, I just want to share a link to download a free copy of Microsoft Press eBook ‘Introducing Microsoft® SQL Server 2012’. This could be a great eBook for you to learn and know about what’s insid
Author:
Anil
Date: 3/26/2012 Section:
Blog
tags :
SQL 2012
ssis package deployment
Devin said it all. If you want to know more techniques to deploy package, take a look at my video .
Author:
marcoadf
Date: 1/7/2012 Section:
Forum
tags :
deploy
,
deployment
,
manifest
,
Package
,
techniques
SSIS Clarification: Loading Data from db to Excel
If you treat the data as a memo however, you might be able to do what you're after. This link has instructions toward the bottom. This is dealing with an Excel source - not destination as you're after, but it might get you going in the right direction. ht
Author:
KeithHyer
Date: 7/15/2011 Section:
Forum
tags :
destination
,
ssis
,
excel
Parent/Child Help
You've got a few options with SSIS. You could "do the work" in T-SQL as an execute SQL task. One method would be modifying something like what is shown here: http://www.sqlservercentral.com/scripts/Miscellaneous/31913/ - I'd use a regular table instead of
Author:
KeithHyer
Date: 5/17/2011 Section:
Forum
tags :
pivot
,
script task destination
,
delimited string
Keep group details on same page
Seems like it might be a bug... http://connect.microsoft.com/SQLServer/feedback/details/428595/keep-together-property-not-working-in-ssrs-2008
Author:
MikeDavis
Date: 7/14/2010 Section:
Forum
tags :
2008
,
Grouping
,
SSRS
Show 0 in results instead of not showing anything
Like this? <SemanticQuery xmlns=" http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling " xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:qd=" http://schemas.microsoft.com/sqlserver
Author:
mesponda
Date: 4/8/2013 Section:
Forum
Address Problem
Yesterday on http://www.SQLServerCentral.com/ there was an article ( linked ) from http://www.mssqltips.com/ which dealt with validating and cleaning data using regular expressions in a SQL CLR function. I'm thinking it would helpful to you if not exactly
Author:
KeithHyer
Date: 3/4/2011 Section:
Forum
tags :
data cleaning
,
parsing
,
regular expressions
How to create Day,Month,yearwise Cube in SSAS
about time dimension, there is some posts about it. take a look at: Mike's post in2bi's post In SSAS, there is this link with a good tutorial on how to build time dimension in your as cube. If this helps you, mark post as answered please. Best regards.
Author:
marcoadf
Date: 2/10/2012 Section:
Forum
tags :
build
,
dimension
,
table
,
time
Determine SSIS Execution Order Programmatically
How do I determine the execution order or parent/child relationship of each object in an SSIS package? I am extracting data out of my SSIS 2008 packages programmatically using SqlServer.Dts.Runtime. I have all the data already. I am now trying to figure o
Author:
MrPerson
Date: 2/27/2011 Section:
Forum
tags :
SqlServer.Dts.Runtime
,
ssis
Adding expression to Derived Column Transformation
Try setting this up ( I'm assuming SQL 2005 - with VB.Net being your scripting language ). 1) 3 string variables: PathToExcel maybe set it to C:\Temp\ -- copy 3 or 4 xls files to this folder. ExcelFileMark This might be *.xls for office 2003 or *.xlsx for
Author:
KeithHyer
Date: 4/12/2011 Section:
Forum
tags :
directory
,
file list
,
file system
,
script task
,
latest file
SSIS - Feed new line
njc78 said: basically I need to replace that little square box with new line, might be derived column/script task? I use a little of both. I have had success declaring a variable and setting it within a script task like this: Imports System Imports System
Author:
KeithHyer
Date: 7/29/2011 Section:
Forum
tags :
carriage return
,
line break
,
line feed
,
SSIS
,
CR/LF
How can i write this selected cell value into another predefined cell in Excel using script component or other tools
How can i write this selected cell value into another predefined cell in Excel using script component or other tools? I have installed Office 2003Primary Interop Assemblies and Add Reference Microsoft Office 11 Object Library but Imports Microsoft.Office.
Author:
bsingha
Date: 1/16/2012 Section:
Forum
Package Configuration Questions
I will not say this is best practice - at all - but given only 1 server for production and tesitng, the following might be helpful. 1) http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66426/ -- shows how to store multiple environment c
Author:
KeithHyer
Date: 8/18/2011 Section:
Forum
tags :
Package Configurations
ASP.NET Session Expired in Reporting Services
Brit, I personally have not received it before, but there's always a first right? I think these links may assist you. http://www.sqlservercentral.com/Forums/Topic474978-150-1.aspx#bm475962 If you're using the report viewer control embedded in a Windows or
Author:
briankmcdonald
Date: 8/23/2010 Section:
Forum
tags :
ASP.NET Session Expired
,
SSRS
Page 1 of 7 (163 items)
<< Prev
1
2
3
4
5
6
7
Next >>
Go to page:
[Go]